Home » RDBMS Server » Server Administration » ORA-20000 error (10g/Unix)
ORA-20000 error [message #310913] Wed, 02 April 2008 16:51 Go to next message
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
BlackSwan
Messages: 25046
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?
Previous Topic: partition allocation.
Next Topic: Can not access report server 10g
Goto Forum:
  


Current Time: Thu Dec 08 20:03:42 CST 2016

Total time taken to generate the page: 0.14909 seconds