removing an object from obj$

From: Sheehan, Jeremy <JEREMY.SHEEHAN_at_nexteraenergy.com>
Date: Mon, 1 Aug 2011 11:35:58 -0400
Message-ID: <C3F905167E081B418BFC63B8668D52FF1FE3AEE6D7_at_GOXEXVS03.fplu.fpl.com>



Hello gurus!

My supervisor tasked me to figure out how to remove an invalid object in the database. it's an XML (XDB owned) object and I've used dbms_xmlschema.deleteSchema() to remove the object, but a reference still exists in obj$ and it has a status of 5 (invalid).

Oracle support said to do this .....

delete from obj$ where name=....;

My question is this. Has anyone tried this before? Support said that it's risky and there is the possibility of db corruption.

I'm running 9.2.0.8 on AIX.

TIA! Jeremy

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 01 2011 - 10:35:58 CDT

Original text of this message