Is it possible to rebuild the index for PK(Primary Key) online..?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Is it possible to rebuild the index for PK(Primary Key) online..?

  1. #1
    Join Date
    Jul 2002
    Posts
    205

    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..?

  2. #2
    Join Date
    Aug 2001
    Posts
    267
    No ..If you can ,drop the Primary key and add it again .(Any way you know this)
    Raghu

  3. #3
    Join Date
    Apr 2002
    Location
    Phoenix, AZ
    Posts
    175
    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
  •  


Click Here to Expand Forum to Full Width