Re: Enabling partitioning

you may want to double-check which version you are running. You say Enterprise/Standard Edition for Linux. However, it's either Enterprise or Standard. If I remember right, partitioning isn't available under Standard. When you log into sql*plus, you can check the "Connected to:" info.

HTH. -Kevin

"Carlos Oliveira" <carlos.a.oliveira_at_vizzavi.pt> wrote in message news:20020731115743.6c43988c.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 - 08:19:50 CDT