Partioned table cretation

From: rc <rc_at_spam.com>
Date: Thu, 04 Mar 2004 15:52:53 +0000
Message-ID: <b1ke40dqhi1mc1uk24kfa84hmj69ha9hvf@4ax.com>

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 - 09:52:53 CST