Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Partition primary key in a partitioned table
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
![]() |
![]() |