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
That's easy, you haven't installed Partitioning option, which is (of
course) must have to use this feature.
--
_________________________________________
Dusan Bolek, Ing.
Oracle team leader
Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Fri Feb 22 2002 - 09:33:17 CST
