| Bishal |
Posted: Apr 24, 2008 12:57:32 AM |
Total Post: 160
Joined: Apr, 2008
|
hello friends.When i am trying to update my table using following command
update emp
set ename='Bishal'
where empid=2
It shows following error:
Error at line 1:
ora-01502: Index 'SYS.PK' or partition of index is in unusable state.
WHAT EXACTLY IS THE PROBLEM?
AND WHAT CAN BE THE SOLUTION? |
|
|
 arun |
| Posted: Apr 24, 2008 01:07:37 AM |  |
|
Total Post: 28
Joined: Sep, 2007
|
Pls check the status of that index , and rebuild it.
it will solve the problem
|
|
|
|
|
| GOPU |
| Posted: Apr 24, 2008 01:09:21 AM | |
|
Total Post: 239
Joined: Apr, 2008
|
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
|
|
|
|
|
| Mohammed Taj |
| Posted: Apr 24, 2008 01:09:29 AM | |
|
Total Post: 694
Joined: Jul, 2007
|
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
And don't use SYS schema it is magic/special user.
|
|
|
|
|
| http://shaharear.blogspot.com |
| Posted: Apr 24, 2008 01:10:55 AM | |
|
Total Post: 79
Joined: Apr, 2008
|
DROP the index and make it again OR REBUILD THE INDEX.
(or you may drop the primary key constraint and make it again)
To rearn details please read :
http://sharear.blogspot.com/2007/04/ora-01502.html
Regards
HASAN
http://sharear.blogspot.com
|
|
|
|
|
| Bishal |
| Posted: Apr 24, 2008 01:13:38 AM | |
|
Total Post: 160
Joined: Apr, 2008
|
thanx guys... it worked after rebuilding the index...
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
