SQL & PL/SQL

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!

in what way can an index go in invalid state????????

65484Nov 22 2005 — edited Nov 22 2005

I did a lot of activity in my database and i found one of my index is in invalid state...i got an error
......Error occured is ORA-01502: index 'MUMBAI.SYS_C0013323' or partition of such index is in unusable state......

Can anybody tell me what activity (or set of activies) can lead to invalid state of Index????/
How to check if any other index is is Invalid state????????

Thanx in Advance
Gagan

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 20 2005

Added on Nov 22 2005

4 comments

1,023 views