RE: ORA-01502: index 'SHOPPINGSA.SCAN_YDCMFFLT_IDX2' or partition of such index is in unusable state

George,

I'm assuming that your question is "How do I fix this?"

The answer is:

Are you too lazy to google the error code and get the result?

ORA-01502: index 'string.string' or partition of such index is in unusable state

Cause: 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: DROP the specified index, or REBUILD the specified index, or REBUILD the unusable index partition.

Tom

-----Original Message-----
From: Rusnak, George A. (SEC-Lee) CTR [mailto:george.rusnak_at_deca.mil] Sent: Tuesday, March 08, 2005 1:00 PM
To: oracle-l_at_freelists.org
Subject: ORA-01502: index 'SHOPPINGSA.SCAN_YDCMFFLT_IDX2' or partition of such index is in unusable state

Group,

Al Rusnak
Oracle Certified Professional
DBA - CISIS, Computer Operations

• 804-734-8210
• george.rusnak_at_deca.mil

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l