Partioning Question

From: Frank & Amy Siegel <NorthernSnow_at_worldnet.att.net>
Date: Tue, 30 Nov 1999 17:24:02 -0500
Message-ID: <821j8o$hui$1@bgtnsc02.worldnet.att.net>

Are there any parameters to set for the database to use partitioing? (Please see the error below for the CREATE TABLE) I'm new to Oracle 8 features and can't find this infor in the Oracle doc.

Thanks for your help.
Frank S.
New Hampshire

    CREATE TABLE frank_test_partitioning     (HUBFIDSERVICEFROMDATE DATE,

     HUBCLAIMSTATUSCODE     VARCHAR2(240),
     FPHEOBRUNNUM           VARCHAR2(240)

)

    PARTITION BY RANGE (HUBFIDSERVICEFROMDATE)      (
    --

       partition  BLENDED3_CUR_1997  VALUES LESS THAN
                 ( to_date('19980101 000000', 'YYYYMMDD HH24MISS') )
      TABLESPACE TS_WAR01
      STORAGE (INITIAL 32k  NEXT 32k PCTINCREASE 0)
      PCTFREE 0,
   --
      partition  BLENDED3_CUR_1998 VALUES LESS THaN
             ( to_date('19990101 000000', 'YYYYMMDD HH24MISS') )
      TABLESPACE TS_WAR02
      STORAGE (INITIAL 32k  NEXT 32k PCTINCREASE 0)
      PCTFREE 0,
   --
      partition  BLENDED3_CUR_1999 VALUES LESS THaN
             ( to_date('20000101 000000', 'YYYYMMDD HH24MISS') )
      TABLESPACE TS_WAR02
      STORAGE (INITIAL 32k  NEXT 32k PCTINCREASE 0)
      PCTFREE 0

)

SQL> /
CREATE TABLE frank_test_partitioning
*
ERROR at line 1:
ORA-00439: feature not enabled: Partitioning

SQL> Received on Tue Nov 30 1999 - 16:24:02 CST