Is it possible to rebuild the index for PK(Primary Key) online..?
Is it possible to rebuild the index for PK(Primary Key) online...?
I get the error
ERROR at line 1:
ORA-08108: may not build or rebuild this type of index online.
No ..If you can ,drop the Primary key and add it again .(Any way you know this)
It is not about the Primary Key, I do it all the time.
Online rebuilds are not permitted for:
REVERSE KEY INDEXES
DEFERRABLE UNIQUE CONSTRAINTS
INDEX ORGANIZED TABLES
Additionally the rebuild of indexes online is not permitted when any one of the following options are specified:
Sridhar R Patnam
Click Here to Expand Forum to Full Width