Re: Can Primary Constraints be partitioned

The question is a little incomplete.
You can 'partition the constraint',
meaning that you can partition the
index on which the constraint depends
when it is enabled.

However, if you want to make the index
LOCALLY partitioned, you will find that
a locally partitioned unique index (or
index used to enforce a unique/pk
constraint) has to contain the table
partitioning columns.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Saugato Mukerji wrote in message <8jrndq$266$1_at_gossamer.itmel.bhp.com.au>...


>hi

>

>i am trying to partition a table using a column called DATE_FINISHED

>the table has a primary constraint defined using two other columns.

>

>how can i partition the constraint?

>

>i am using 8.1.5 on NT sp4

>

>thanks in advance

>

>Saugato Mukerji

>

>