RE: removing an object from obj$
Date: Mon, 1 Aug 2011 10:49:18 -0500
Message-ID: <F077F09A0E11504D9E720358BEE994D1084A6F84_at_APSW0553EVS.ms.ds.uhc.com>
I get heartburn when someone says that to me. A "Clean" database versus a possible "Corrupt" database.
Try recreating the xdb items and see if it picks up the reference and does away with the invalid entry.
-----Original Message-----
From: Sheehan, Jeremy [mailto:JEREMY.SHEEHAN_at_nexteraenergy.com]
Sent: Monday, August 01, 2011 10:44 AM
To: Lange, Kevin G; oracle-l_at_freelists.org
Subject: RE: removing an object from obj$
He wants a clean database. We're upgrading soon to 11g and he wants it pristine.
Jeremy
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lange, Kevin G
Sent: Monday, August 01, 2011 11:41 AM
To: oracle-l_at_freelists.org
Subject: RE: removing an object from obj$
I would start with asking him WHY does he want it removed ...... And is it worth the possible db corruption .
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sheehan, Jeremy
Sent: Monday, August 01, 2011 10:36 AM
To: oracle-l_at_freelists.org
Subject: removing an object from obj$
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
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
--
http://www.freelists.org/webpage/oracle-l
This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately.
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Aug 01 2011 - 10:49:18 CDT