Re: how to partition index for primary key

From: Bernhard Seeling <seeling_at_kzvth.ef.uunet.de>
Date: Thu, 23 Sep 1999 13:35:29 +0200
Message-ID: <7sd3dk$k40$1@newsread.do.de.uu.net>

Hi David ,

ALTER TABLE foo
ADD( CONSTRAINT pk_foo PRIMARY KEY(a,b) DISABLE);

CREATE UNIQUE INDEX idx_pk_foo primary key( a, b ) ON foo (a,b) local

      ( PARTITION pk_p1  TABLESPACE TS_foo
           STORAGE (..............) ,
        PARTITION pk_p2   TABLESPACE TS_foo
           STORAGE ( .........   )      nologging) ;

ALTER TABLE foo ENABLE constraint idx_pk_foo USING INDEX;

mfG Bernhard !

dxlin_at_my-deja.com schrieb in Nachricht <7sbjm5$vc8$1_at_nnrp1.deja.com>... Received on Thu Sep 23 1999 - 06:35:29 CDT