Re: Partioned table cretation

At first you need parantheses around "1999001".

At second you simply have an extra left parenthesis : "((MAXVALUE) ".

At third, this newgroup is not a spell checking forum. You are expected to do some basic thinking yourself.

• Kenneth Koenraadt

On Thu, 04 Mar 2004 15:52:53 +0000, rc <rc_at_spam.com> 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);
>
>
>
>
>
>
Received on Thu Mar 04 2004 - 12:57:23 CST