Home » RDBMS Server » Enterprise Manager » ORA 8104
ORA 8104 [message #68584] Wed, 17 March 2004 00:15 Go to next message
Antonio
Messages: 12
Registered: October 2001
Junior Member
I HAVE EXECUTE THE COMMAND FOR INDEX OF 4GB

alter index csi.DC_C_FK_I rebuild TABLESPACE CSI_ALL_INDEX compute statistics online; FOR ERROR I HAVE KILL THE PROCESS AND NOW I HAVE always
THE ERROR ORA 08104 HOW DO YOU DO

Thanks

Sorry for my english
Re: ORA 8104 [message #68586 is a reply to message #68584] Tue, 23 March 2004 02:01 Go to previous message
Frank Naude
Messages: 4571
Registered: April 1998
Senior Member
Hi,

08104, 00000, "this index object %s is being online built or rebuilt"
// *Cause: the index is being created or rebuild or waited for recovering
// from the online (re)build
// *Action: wait the online index build or recovery to complete

You need to ensure the job runs through (do not kill it midway). If it is too late, and you cannot wait for the cleanup, try to drop the index with the 'force' option:

SQL> drop index index_name force;


Best regards.

Frank
Previous Topic: URGENT - Failing to find a class while deploying using OEM
Next Topic: Oracle Parallel Server
Goto Forum:
  


Current Time: Tue May 17 19:37:46 CDT 2022