removing an object from obj$

From: "Sheehan, Jeremy" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>
To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
Date: Mon, 1 Aug 2011 11:35:58 -0400

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

Follow-Ups:
- RE: removing an object from obj$
  - From: Lange, Kevin G
- RE: removing an object from obj$
  - From: Goulet, Richard

References:
- Re: session timeout on metalink
  - From: Derya Oktay
- RE: session timeout on metalink
  - From: Joel.Patterson
- RE: session timeout on metalink
  - From: Taylor, Chris David
- RE: session timeout on metalink
  - From: Rich Jesse

removing an object from obj$

Other related posts: