Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Partition do not work

Partition do not work

From: Marcelo <oraclevelasquez_at_bol.com.br>
Date: 22 Feb 2002 03:08:30 -0800
Message-ID: <ffaa3dc2.0202220308.2571c72a@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 - 05:08:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US