Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How to avoid or handle the ORA-0054s

Re: How to avoid or handle the ORA-0054s

From: <J.Velikanovs_at_alise.lv>
Date: Sun, 2 Jan 2005 15:51:48 +0200
Message-ID: <OFB360AEC3.E04E5D18-ONC2256F7D.004C02AB-C2256F7D.004C7AB9@alise.lv>


Hemant,
Another simple method to achieve your purpose:

DROPME:gonza> lock table testddl in exclusive mode; -- Waiting until all concurrent DML has been done.

Table(s) Locked.

DROPME:gonza> alter index testddl_i1 rebuild;

Index altered.

PS Replace "alter ... rebuild;" with "drop index ... ; lock table ...; create index ..." if you want.

Jurijs
+371 9268222 (+2 GMT)



Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

Jurijs
+371 9268222 (+2 GMT)



Thank you for teaching me.
http://otn.oracle.com/ocm/jvelikanovs.html

Hemant K Chitale <hkchital_at_singnet.com.sg> Sent by: oracle-l-bounce_at_freelists.org
01.01.2005 05:05
Please respond to hkchital  

        To:     oracle-l_at_freelists.org
        cc: 
        Subject:        How to avoid or handle the ORA-0054s



I have a need to regularly Recreate certain Indexes . {see note below on WHY !}
This is scripted. However, the script sometimes errors on the DROP with ORA-0054
and, of course, the CREATE doesn't go through. We are trying to put a loop to check the spooled output of the script and rerun
it if the DROP fails.

However, I was wondering if anyone has implemented a technique to handle ORA-0054s
and automated the retry of the DDL.

Why I can't use a REBUILD is because it is a corrupt index. {and surely, the REBUILD does use a WAIT when it switches the indexes. Why doesn't Oracle allow us to write a DROP ... WAIT ?}

NOTE : Why the Recreate Indexes :
These are 6 BitMap Join Indexes. A bug in 9.2.0.4 causes occasional ORA-600s
when querying the table. The solution is to Recreate the Indexes. I had emailed
this list on 03-Dec on ORA-600 [12700] errors with these BMJIs.

Although 9.2.0.5 is indicated to have a fix, I see some references to other
BMJI issues in 9.2.0.5 and we haven't yet gone to 9.2.0.5 for this particular database.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital  

--
http://www.freelists.org/webpage/oracle-l



--
http://www.freelists.org/webpage/oracle-l
Received on Sun Jan 02 2005 - 07:53:20 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US