Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Partition do not work
And, let us not forget, is an extra cost option even there!
Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message
news:a20d28ee.0202220615.12dcffb6_at_posting.google.com...
> oraclevelasquez_at_bol.com.br (Marcelo) wrote in message
news:<ffaa3dc2.0202220308.2571c72a_at_posting.google.com>...
> > Hi
> >
> > I am trying to create a table, but return me error
> >
> > CREATE TABLE HST_PROMO
> > (DT_PROMOCAO DATE NOT NULL
> > ,CD_MAT NUMBER(5) NOT NULL
> > ,VL_SAL NUMBER(9,2)
> > ,CD_DEPTO CHAR(3)
> > ,NR_CARGO NUMBER(3)
> > ,TX_MOTIVO VARCHAR2(200)
> > ,PRIMARY KEY (DT_PROMOCAO,CD_MAT))
> > STORAGE (INITIAL 4K
> > NEXT 4K
> > MINEXTENTS 1
> > MAXEXTENTS 15)
> > PCTFREE 10
> > PCTUSED 80
> > PARTITION BY RANGE (DT_PROMOCAO)
> > (PARTITION ANOS80 VALUES LESS THAN (TO_DATE('01011990','DDMMYYYY')),
> > PARTITION ANOS90_94 VALUES LESS THAN (TO_DATE('01011995','DDMMYYYY')),
> > PARTITION ANOS95_99 VALUES LESS THAN (TO_DATE('01012000','DDMMYYYY')),
> > PARTITION ANOS2000 VALUES LESS THAN (MAXVALUE));
> >
> > ORA-00439: recurso não ativado: Partitioning
> > Excuse but my Oracle is Portuguese version
> >
>
>