Re: Partition do not work

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

You are running the Standard Edition. The Partition Option is available only in the Enterprise Edition.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 22 2002 - 08:15:10 CST