| ORA-01502 [message #365061] |
Wed, 10 December 2008 16:08  |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
Hi, I am getting the following error while trying to drop a user with casacde optioni:
ORA-01502: index 'SYS.I_ACCESS1' or partition of such index is in unusable state
Before that I was doing an import which terminated without errors. I shutdown the database and now cannot start it back up. Here are the contents of the alert file:
Errors in file /data/app/oracle/admin/rmsprod/udump/rmsprod_ora_22198.trc:
ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-01502: index 'SYS.I_ACCESS1' or partition of such index is in unusable state
Wed Dec 10 16:48:14 2008
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 22198
ORA-1092 signalled during: ALTER DATABASE OPEN...
Please advise! Thank you!
[Updated on: Wed, 10 December 2008 16:13] Report message to a moderator |
|
|
|
| Re: ORA-01502 [message #365065 is a reply to message #365061] |
Wed, 10 December 2008 16:27  |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
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 have you looked at the file rmsprod_ora_22198.trc for additional information?
|
|
|
|
|
|
|
|
| Re: ORA-01502 [message #365346 is a reply to message #365118] |
Thu, 11 December 2008 10:40 |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
|
I would like to know that also. There was no activity in the db except of an import of a schema from a different db. After the import I got this message. Yes, restore and recover, but it would be nice know what produced this behavior. Thank you!
|
|
|
|
|
|
|
|
| Re: ORA-01502 [message #365364 is a reply to message #365360] |
Thu, 11 December 2008 13:39 |
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
|
Senior Member |
|
|
Yes.
That has most likely destroyed the database and put in in an unusable state.
Don't EVER touch the sys schema with imports/exports or put own database objects in it.
|
|
|
|
| Re: ORA-01502 [message #365366 is a reply to message #365364] |
Thu, 11 December 2008 13:50 |
lotusdeva
Messages: 201
Registered: March 2005
|
Senior Member |
|
|
|
Ok, thank you! I tried to search docs about it and it does not say anywhere that you cant use SYS to do imports, etc. I learned my lesson though.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
