Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Enabling partitioning

Re: Enabling partitioning

From: Epicentre Team B Annecy <carmanet_at_epicentre.fr>
Date: Wed, 31 Jul 2002 18:09:59 +0200
Message-ID: <ai9232$83l$1@wanadoo.fr>


Hello Carlos,

I checked the syntax, and had an error with the fourth partition: try "PARTITION sales_q4" instead of "PARTITION sales q4", then it worked for me.

HTH

--
Celine Armanet - Division ORACLE
EPICENTRE - 529 Route des Vernes 74370 PRINGY
carmanet_at_epicentre.fr
Tel. : +33 04 50 09 7000
"Carlos Oliveira" <carlos.a.oliveira_at_vizzavi.pt> a écrit dans le 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 - 11:09:59 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US