| ORA 8104 [message #68584] |
Wed, 17 March 2004 00:15  |
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  |
Frank Naude
Messages: 4581
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
