Re: global index - composite partitions

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
  • Date: Mon, 17 Nov 2008 18:47:51 +0700

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


Other related posts: