Re: global index - composite partitions
From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Mon, 17 Nov 2008 18:47:51 +0700
Message-ID: <3edcb66e0811170347y7be78376pa026bdb9d7be0aee@mail.gmail.com>
............
............
CONSTRAINT PVC_PK
PRIMARY KEY
(AN, SEQ, ES, ETI, ER)
)
ORGANIZATION INDEX <=== IOT :(
PARTITION BY RANGE (SEQ)
........... (500 partitions even more)
)
NOPARALLEL; here I'm trying to create global index with subpartitions:
.............
..........
PARTITION p9999 VALUES LESS THAN (MAXVALUE) ) ;
Date: Mon, 17 Nov 2008 18:47:51 +0700
Message-ID: <3edcb66e0811170347y7be78376pa026bdb9d7be0aee@mail.gmail.com>
dennis,
here the table partitions:
CREATE TABLE PVC
(
AN VARCHAR2(20 BYTE) NOT NULL, SEQ NUMBER(9) NOT NULL, ES VARCHAR2(40 BYTE) NOT NULL, ETI NUMBER(9) NOT NULL, ER VARCHAR2(16 BYTE) NOT NULL, CSI NUMBER(9) NOT NULL, CRD DATE NOT NULL, EVD DATE NOT NULL, ..........
............
............
CONSTRAINT PVC_PK
PRIMARY KEY
(AN, SEQ, ES, ETI, ER)
)
ORGANIZATION INDEX <=== IOT :(
PARTITION BY RANGE (SEQ)
........... (500 partitions even more)
)
NOPARALLEL; here I'm trying to create global index with subpartitions:
create index idx_g_pvc on pvc(AN,EVD,ETI,ES)
partition by range(EVD)
subpartition by hash(AN) subpartitions 512
(PARTITION p0106 VALUES LESS THAN (TO_DATE('01-01-2006', 'DD-MM-YYYY')), PARTITION p0206 VALUES LESS THAN (TO_DATE('01-02-2006', 'DD-MM-YYYY')), PARTITION p0306 VALUES LESS THAN (TO_DATE('01-03-2006', 'DD-MM-YYYY')), PARTITION p0406 VALUES LESS THAN (TO_DATE('01-04-2006', 'DD-MM-YYYY')), PARTITION p0506 VALUES LESS THAN (TO_DATE('01-05-2006', 'DD-MM-YYYY')), PARTITION p0606 VALUES LESS THAN (TO_DATE('01-06-2006', 'DD-MM-YYYY')), PARTITION p0706 VALUES LESS THAN (TO_DATE('01-07-2006', 'DD-MM-YYYY')), PARTITION p0806 VALUES LESS THAN (TO_DATE('01-08-2006', 'DD-MM-YYYY')), .........
.............
..........
PARTITION p9999 VALUES LESS THAN (MAXVALUE) ) ;
this always given error during index creation :(
-- thanks and regards ujang | oracle dba jakarta | http://ora62.wordpress.com On Fri, Nov 14, 2008 at 3:54 AM, Dennis Williams <oracledba.williams_at_gmail.com> wrote: > Ujang, > > How did you partition your table? > > Dennis Williams > > -- http://www.freelists.org/webpage/oracle-lReceived on Mon Nov 17 2008 - 05:47:51 CST