Re: Enabling partitioning

Thank you for your help.

I noticed the error that you report, but that is not the problem. The problem in my case is that even with the _ i get  

ORA-00439: feature not enabled: Partitioning

Thank you

Carlos

On Wed, 31 Jul 2002 18:09:59 +0200
"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> wrote:

> 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:47:07 CDT