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.
Any idea..?
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.
Any idea..?
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
FUNCTIONAL 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:
SPLIT PARTITION
COMPUTE STATISTICS
UNUSABLE
