Partitioned unique index with unique values across the entire table!
Ask_DevJan 17 2012 — edited Jan 17 2012Hi,
I would like to know if it is possible to have a partitioned unique index on a table?
Business Case:
A certain column of the table is to have unique values across the entire table. However, because of the size of the table we have the table partitioned.
In order to keep the unique values, the index is global.
The problem:
Whenever we do a partition maintenance the index becomes invalid and we have to rebuild the entire index which can take 3 to 5 hours.
Is it possible then to have the index local but unique across the entire table?
The database version is 11.2.0.2.4
regards
samuelk