Re: Partition do not work

Execiute this query as SYS:

  SELECT * from v$OPTION
  where parameter = 'Partitioning';

and look, what is the value...
If it is FALSE, You must reinstall your's product Oracle'a with this option.

Marcelo wrote:

> 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 - 06:23:10 CST