Re: Partioned table cretation

rc wrote:

> HI
>
> I am trying to create this table with this script and it falls over
> with
>
> PARTITION current_period VALUES LESS THAN 1999001 TABLESPACE DEM_PART1
> ORA-00906: missing left parenthesis
>
> Can any one point out the error to me, I am new to oracle
>
> Oracle 8.1.7.4 on Solaris 8
>
>
> CREATE TABLE SALFLDGDEM (
> ACCNT_CODE CHAR (15) NOT NULL,
> PERIOD NUMBER (7) NOT NULL,
> TRANS_DATE NUMBER (8) NOT NULL,
> JRNAL_NO NUMBER (7) NOT NULL,
> JRNAL_LINE NUMBER (7) NOT NULL,
> AMOUNT NUMBER (18,3) NOT NULL,
> D_C CHAR (1) NOT NULL,
> ALLOCATION CHAR (1) NOT NULL,
> JRNAL_TYPE CHAR (5) NOT NULL,
> JRNAL_SRCE CHAR (5) NOT NULL,
> TREFERENCE CHAR (15) NOT NULL,
> DESCRIPTN CHAR (25) NOT NULL,
> ENTRY_DATE NUMBER (8) NOT NULL,
> ENTRY_PRD NUMBER (7) NOT NULL,
> DUE_DATE NUMBER (8) NOT NULL,
> ALLOC_REF NUMBER (9) NOT NULL,
> ALLOC_DATE NUMBER (8) NOT NULL,
> ALLOC_PERIOD NUMBER (7) NOT NULL,
> ASSET_IND CHAR (1) NOT NULL,
> ASSET_CODE CHAR (10) NOT NULL,
> ASSET_SUB CHAR (5) NOT NULL,
> CONV_CODE CHAR (5) NOT NULL,
> CONV_RATE NUMBER (18,9) NOT NULL,
> OTHER_AMT NUMBER (18,3) NOT NULL,
> OTHER_DP CHAR (1) NOT NULL,
> CLEARDOWN CHAR (5) NOT NULL,
> REVERSAL CHAR (1) NOT NULL,
> LOSS_GAIN CHAR (1) NOT NULL,
> ROUGH_FLAG CHAR (1) NOT NULL,
> IN_USE_FLAG CHAR (1) NOT NULL,
> ANAL_T0 CHAR (15) NOT NULL,
> ANAL_T1 CHAR (15) NOT NULL,
> ANAL_T2 CHAR (15) NOT NULL,
> ANAL_T3 CHAR (15) NOT NULL,
> ANAL_T4 CHAR (15) NOT NULL,
> ANAL_T5 CHAR (15) NOT NULL,
> ANAL_T6 CHAR (15) NOT NULL,
> ANAL_T7 CHAR (15) NOT NULL,
> ANAL_T8 CHAR (15) NOT NULL,
> ANAL_T9 CHAR (15) NOT NULL,
> POSTING_DATE NUMBER (8) NOT NULL,
> ALLOC_IN_PROGRESS CHAR (1) NOT NULL,
> HOLD_REF NUMBER (5) NOT NULL,
> HOLD_OP_ID CHAR (3) NOT NULL)
> PARTITION BY RANGE (PERIOD)
> (
> PARTITION current_period VALUES LESS THAN 1999001 TABLESPACE
> DEM_PART1,
> PARTITION other_period VALUES LESS THAN ((MAXVALUE) TABLESPACE
> DEM_PART2);
You'll have to help me here. I'm still horrified by your use of CHAR columns and the obvious lack of normalization. Are you sure you really want to build this?

But ... for examples:
http://www.psoug.org/reference/partitions.html

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)