Re: removing an object from obj$
Date: Wed, 3 Aug 2011 13:52:52 +0800
Message-ID: <CAB=aETAK4iV2+j4WzFRVcAgOF606x9isxSPBTdxiMN7Ym91kEA_at_mail.gmail.com>
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_at_parexel.com>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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Mercadante, Thomas F (LABOR)
> Sent: Tuesday, August 02, 2011 7:42 AM
> To: JEREMY.SHEEHAN_at_nexteraenergy.com; oracle-l_at_freelists.org
> Subject: RE: removing an object from obj$
>
> Maybe this was a "teaching moment" for you?
>
> LOL!
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Sheehan, Jeremy
> Sent: Monday, August 01, 2011 3:56 PM
> To: Goulet, Richard; oracle-l_at_freelists.org
> 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_at_parexel.com]
> Sent: Monday, August 01, 2011 3:33 PM
> To: Sheehan, Jeremy; oracle-l_at_freelists.org
> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Sheehan, Jeremy
> Sent: Monday, August 01, 2011 11:36 AM
> To: oracle-l_at_freelists.org
> 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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- Connor McDonald =========================== email: connor_mcdonald_at_yahoo.com web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat" -- http://www.freelists.org/webpage/oracle-lReceived on Wed Aug 03 2011 - 00:52:52 CDT