ORA-20000 error [message #310913] |
Wed, 02 April 2008 16:51 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
liamadherne
Messages: 40 Registered: March 2008 Location: Philadelphia
|
Member |
|
|
MVPAIRING 03/04/08 00:00:01
Hello Everybody,
I have found an Ora-20000 error often in the alert log.
below is a piece of alert log error message .
Errors in file /gstsoft/ora10/admin/gstdb/bdump/gstdb_j000_16537.trc:
ORA-20000: index "SYS"."WRH$_ACTIVE_SESS_HIST_PK" or partition of such index is in unusable state
Please suggest what could be the problem.
Thanks for your time.
Liam Adherne.
|
|
|
Re: ORA-20000 error [message #310915 is a reply to message #310913] |
Wed, 02 April 2008 17:12 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/136107.jpg) |
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
>Please suggest what could be the problem.
index "SYS"."WRH$_ACTIVE_SESS_HIST_PK" or partition of such index is in unusable state
This could result from INSERT /* APPEND */ or SQLLDR
Was this a test of our reading & comprehension abilities?
|
|
|