Either you did not install the partitioning option when you installed
the software or you are using the STANDARD edition of the software
(partitioning is only in the ENTERPRISE edition).
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
Received on Fri Feb 22 2002 - 08:22:03 CST
