Oracle DB Error ORA-01502 index string.string or partition of such index is in unusable state

Oracle DB Error ORA-01502 index string.string or partition of such index is in unusable state

The following is the cause of this error:

An attempt has been made to access an index or index partition that has been marked unusable by a direct load or by a DDL operation.

Action you can take to resolve this issue: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.


Tags: Database, Education, Software




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution