Solution: rebuild this index
ALTER INDEX RESUME_PK REBUILD
After I executed this rebuild action, it turned out to be normal.
Reference
[1] http://www.mydigitallife.info/2006/01/28/ora-01502-oracle-index-in-unusable-state/
2009/04/16
ORA-01502 Oracle Index in Unusable State
As I execute sql statement to do search, it return this message unexpectedly:ORA-01502: index 'RSDB.RESUME_PK' or partition of such index is in unusable state
Solution: rebuild this index
After I executed this rebuild action, it turned out to be normal.
Reference
[1] http://www.mydigitallife.info/2006/01/28/ora-01502-oracle-index-in-unusable-state/
Solution: rebuild this index
After I executed this rebuild action, it turned out to be normal.
Reference
[1] http://www.mydigitallife.info/2006/01/28/ora-01502-oracle-index-in-unusable-state/
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment