Re: removing an object from obj$

  • From: Connor McDonald <mcdonald.connor@xxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 3 Aug 2011 13:52:52 +0800

Ah...we've all been there.  Like the old days at Uni (college), when you
would add:

alias ls='rm -rf *'

to someone's profile....



On Tue, Aug 2, 2011 at 9:15 PM, Goulet, Richard
<Richard.Goulet@xxxxxxxxxxx>wrote:

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


-- 
Connor McDonald
===========================
email: connor_mcdonald@xxxxxxxxx
web:   http://www.oracledba.co.uk

"Semper in excremento, sole profundum qui variat"

Other related posts:

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