Partitioning not enabled

From: Carlos Oliveira <carlos.a.oliveira_at_vizzavi.pt>
Date: Wed, 31 Jul 2002 18:00:09 +0100
Message-ID: <20020731180009.25aa0d24.carlos.a.oliveira_at_vizzavi.pt>

Hi,

When running this example:

CREATE TABLE sales
( invoice_no NUMBER,

sale_year INT NOT NULL,
sale_month INT NOT NULL,
sale_day INT NOT NULL )

STORAGE (INITIAL 100K NEXT 50K) LOGGING
PARTITION BY RANGE ( sale_year, sale_month, sale_day)
( PARTITION sales_q1 VALUES LESS THAN ( 1999, 04, 01 )
TABLESPACE tsa STORAGE (INITIAL 20K NEXT 10K), PARTITION sales_q2 VALUES LESS THAN ( 1999, 07, 01 ) TABLESPACE tsb,
PARTITION sales_q3 VALUES LESS THAN ( 1999, 10, 01 ) TABLESPACE tsc,
PARTITION sales_q4 VALUES LESS THAN ( 2000, 01, 01 ) TABLESPACE tsd)
ENABLE ROW MOVEMENT; I get this error message:

ORA-00439: feature not enabled: Partitioning

Partitioning is installed as i can confirm with the Oracle Installer.

How do i enable the partitioning feature?? I'm using a Oracle9i Database Release 2 Enterprise/Standard Edition for Linux under Suse Linux 8.0, downloaded from Oracle web site.

Thank you in advance for your help

Carlos Received on Wed Jul 31 2002 - 19:00:09 CEST