OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » ORA 08104

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA 08104 [message #60956]

Wed, 17 March 2004 00:13

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

Sorry for my english

�

Report message to a moderator

Re: ORA 08104 [message #60957 is a reply to message #60956]

Wed, 17 March 2004 00:18

Ken Jones
Messages: 70
Registered: January 2004

Member

Antonio,

ORA-08104 this index object string 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.

I think the error is arising because you are killing the process while it is still active. How long is the compute statistics running and when was the last time that statistics were created?

Also what version and OS?

Ken

Report message to a moderator

Re: ORA 08104 [message #60958 is a reply to message #60957]

Wed, 17 March 2004 00:26

Antonio
Messages: 12
Registered: October 2001

Junior Member

The last time that statistics were created
24/01/2004 2.56.58
The version is HP-UX11I for Oracle 9i
My question is how recover the situations

Report message to a moderator

Re: ORA 08104 [message #60959 is a reply to message #60956]

Wed, 17 March 2004 01:14

Anatol Ciolac
Messages: 113
Registered: December 2003

Senior Member

I think that will be useful to store a create script for index, delete them, and when will be no so much work to database to create them. Or you must to rebuild them. Think that both variants will last some time.

Report message to a moderator

Re: ORA 08104 [message #60967 is a reply to message #60956]

Wed, 17 March 2004 04:10

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

it is an oracle Bug.
try

check the status of index.
   if invalid then
       DROP INDEX that_particular_index FORCE;
recreate the index.

Please be aware that, interfering online index rebuild is NOT A RECOMENDED procedure.

with 9i, it is better to use DBMS_STATS to collect the statistics and DELETE THE old statistics before collecting new ( which is a workaround for another bug..an ora-0600 erros shoots if the table has some old stats in it!.)

Report message to a moderator

Re: ORA 08104 [message #60982 is a reply to message #60958]

Thu, 18 March 2004 00:08

IA
Messages: 91
Registered: March 2004

Member

Hi,

I suggest your drop the index.

Create the index with the parallel option. Much faster and hopefully will avoid this problem.

IA.

Report message to a moderator

Previous Topic:	to build a database manually
Next Topic:	Tuning Issue Urgent

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:53:00 CDT 2024