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!
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-lReceived on Mon Aug 01 2011 - 10:35:58 CDT