Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

REBUILD INDEX ONLINE

85972Feb 22 2010 — edited Feb 23 2010

I have a partitioned table with global indexes. Now we have decided to make our indexes local, is there any way to do this online? I Tried to rebuild but didn't work. Is there anything similar? I would hate to create downtime just for this.

SQL> ALTER INDEX ORIGINAL_TRANSACTION_FK LOCAL REBUILD ONLINE;
ALTER INDEX ORIGINAL_TRANSACTION_FK LOCAL REBUILD ONLINE
*
ERROR at line 1:
ORA-02243: invalid ALTER INDEX or ALTER MATERIALIZED VIEW option

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 23 2010

Added on Feb 22 2010

#general-database-discussions

5 comments

2,798 views