-
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.
Any idea..?
-
No ..If you can ,drop the Primary key and add it again .(Any way you know this)
Raghu
-
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
Sridhar R Patnam
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|