| Ora-01502 [message #53068] |
Tue, 27 August 2002 06:55  |
Helena
Messages: 42
Registered: February 2002
|
Member |
|
|
Hi there
One of my db user si getting this error message
ORA-01502: index 'PERFAI.ACCOUNT3_I' or partition of such index is in unusable state
Can someone please tell me what to do in this case
Thanks
|
|
|
|
| Re: Ora-01502 [message #53072 is a reply to message #53068] |
Tue, 27 August 2002 07:58  |
SKS
Messages: 26
Registered: February 2002
|
Junior Member |
|
|
USE:
ALTER SESSION SET SKIP_UNUSABLE_INDEXES=TRUE;
Explaination:
SKIP_UNUSABLE_INDEXES=TRUE -> disables error reporting of indexes marked as unusable. Allows inserts, deletes, and updates to tables with unusable indexes
or index partitions.
SKIP_UNUSABLE_INDEXES=FALSE -> enables error reporting of indexes marked as unusable. Does not allow inserts, deletes, and updates to tables with unusable
indexes or index partitions. **This is the default.
|
|
|
|
| Re: Ora-01502 [message #60942 is a reply to message #53072] |
Mon, 15 March 2004 21:02 |
Puneet Mathur
Messages: 1
Registered: March 2004
|
Junior Member |
|
|
There are great problems here if i set the skip_unsuable true option the session hangs for indefinite time period and shows up in v$session_longops
So what to do next
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
