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!

ORA-01502: index 'SYS.I_DEPENDENCY1' index is in unusable state

930862Apr 16 2012 — edited Apr 18 2012

In a regular activity of MOVE tables from Oracle 10g database, Unfortunately I run script to MOVE sys tables.Which got my SYS indexes in unusable state and bring my database down.

Now while startup I am getting below error

ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_DEPENDENCY1' or partition of such index is in unusable state

Is there any way to startup my database, we dont have database backup to restore.

Please help..

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2012

Added on Apr 16 2012

#data, #database, #dba, #general-database-discussions

9 comments

778 views