RE: removing an object from obj$

  • From: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
  • To: "Thomas.Mercadante@xxxxxxxxxxxx" <Thomas.Mercadante@xxxxxxxxxxxx>, "JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx" <JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 2 Aug 2011 13:15:55 +0000

Sounds like even the mighty can on occasion make mistakes.

Long story, made short.  HP customer tech manager pinch hitting on a day when 
things were tight.  Very good person had been to our facility before, pulled a 
few out of the fire that we did not think could be saved.  Installed HP Service 
Guard on a set of servers which took all day for various reasons.  At the end 
he wanted to delete a directory he had created off of the root file system 
called saveme.  Entered at the command prompt:

 Rm -fr /

System obliged.

Richard Goulet
Senior Oracle DBA/Na Team Leader

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Mercadante, Thomas F (LABOR)
Sent: Tuesday, August 02, 2011 7:42 AM
To: JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: RE: removing an object from obj$

Maybe this was a "teaching moment" for you?

LOL!

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sheehan, Jeremy
Sent: Monday, August 01, 2011 3:56 PM
To: Goulet, Richard; oracle-l@xxxxxxxxxxxxx
Subject: RE: removing an object from obj$

I realize that invalid objects generally are ok to have in a database.  We've 
got them elsewhere, but for some reason he wants it all clean.  My supervisor 
(he's one of my 3) is a senior level DBA.  He's very technical and very good at 
what he does. Not to say that we don't butt heads occasionally, but I'll give 
it to him that he's one of the better DBA's I've met.

We did find out today that the upgrade from 9i to 11g does, in fact, fix this 
problem.  No need to edit dictionary objects at all.  YAY!

Thanks all for your suggestions!  

Jeremy 


-----Original Message-----
From: Goulet, Richard [mailto:Richard.Goulet@xxxxxxxxxxx] 
Sent: Monday, August 01, 2011 3:33 PM
To: Sheehan, Jeremy; oracle-l@xxxxxxxxxxxxx
Subject: RE: removing an object from obj$

Jeremy,

        I've done upgrades from 4.0 right up through 11.2 with invalid objects 
in the database and it does not cause a problem 99.99999% of the time.  The 
remaining 0.00001% of the time the database had to be upgraded via 
import/export for other reasons, like trying to get 6.0.33 to 8.1.  Way too big 
a jump.  Also if it's an Oracle core object like for XDB the upgrade will take 
care of it all by itself.  There is no reason to go messing around in core 
Oracle tables and risking database corruption.  It's not the number of invalid 
objects that you have going into an upgrade,  It's the number you have AFTER 
the upgrade that really matters.  So tell your boss to learn to live with it.

Darn, really love it when non-techie managers make techie decisions for you.  
Like killing a dragon with a wet noodle.

Richard Goulet
Senior Oracle DBA/Na Team Leader

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Sheehan, Jeremy
Sent: Monday, August 01, 2011 11: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




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




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