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@xxxxxxxxx> wrote: > Ujang, > > How did you partition your table? > > Dennis Williams > > -- //www.freelists.org/webpage/oracle-l