Home » SQL & PL/SQL » SQL & PL/SQL » ORA-01502: index 'CCMSLIVE.SYS_C006632' or partition of such index is in unusable state
icon5.gif  ORA-01502: index 'CCMSLIVE.SYS_C006632' or partition of such index is in unusable state [message #200069] Fri, 27 October 2006 14:09 Go to next message
netbirds
Messages: 2
Registered: October 2006
Junior Member
Hi All,

I got this SQL Exception, when i try to query a table call CMS_CUSTOMER....

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

can anyone help me...

Thanks in advance,
-Netbirds
Re: ORA-01502: index 'CCMSLIVE.SYS_C006632' or partition of such index is in unusable state [message #200071 is a reply to message #200069] Fri, 27 October 2006 14:17 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
You load the table using SQL*loader?
dev1>>oerr ora 1502
01502, 00000, "index '%s.%s' or partition of such index is in unusable state"
// MERGE: 1489 RENUMBERED TO 1502
// *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
Previous Topic: sysout
Next Topic: updating a table
Goto Forum:
  


Current Time: Wed Dec 07 14:22:26 CST 2016

Total time taken to generate the page: 0.05118 seconds