RE: removing an object from obj$

  • From: "Lange, Kevin G" <kevin.lange@xxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 1 Aug 2011 10:49:18 -0500

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@xxxxxxxxxxxxxxxxx] 
Sent: Monday, August 01, 2011 10:44 AM
To: Lange, Kevin G; oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Lange, Kevin G
Sent: Monday, August 01, 2011 11:41 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Sheehan, Jeremy
Sent: Monday, August 01, 2011 10:36 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//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.

--
//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.

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


Other related posts: