RE: removing an object from obj$

  • From: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
  • To: "kevin.lange@xxxxxxxxxx" <kevin.lange@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Mon, 1 Aug 2011 11:44:18 -0400

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




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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 08-2011