| ORA-20000 error [message #310913] |
Wed, 02 April 2008 16:51  |
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  |
 |
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
