Re: Cannot partition the table
That's just a requirement for partitions currently.
Any unique index must include the partition key. It may not make logical sense to add the partition key into the unique index if it's not necessary to include it for uniqueness, but adding id to the end of your unique index probably wouldn't add much overhead given the advantage of being able to partition by range on id.
It will take up more space, but I don't think you can get around that currently.
Subject
Views
Written By
Posted
7094
December 29, 2008 03:10PM
Re: Cannot partition the table
3500
December 30, 2008 12:07AM
3199
January 01, 2009 06:03AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.