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 primary key in a partitioned table

Partition primary key in a partitioned table

From: JZ <ibm_97_at_yahoo.com>
Date: 11 Apr 2003 15:01:24 -0700
Message-ID: <10bc841c.0304111401.2d15781e@posting.google.com>


Oracle 9iR2

A table has 2 cols: id, timestamp
I range partition the table on 'timestamp' column. Now I want to add primary key constraint on 'id' column. And I wanna partition the primary key index also.

Looks like I cannot local non-prefixed partition the PK index. right? Which other partition methods (local, global, hash, range, prefixed, non-prefixed) can I use on this PK index? What's the syntax to do this? (should begin 'alter table add constraint...')

Thanks a lot! Received on Fri Apr 11 2003 - 17:01:24 CDT

Original text of this message

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