Re: removing an object from obj$
Date: Mon, 1 Aug 2011 13:19:25 -0300
Message-ID: <CAJ2dSGS2hFFn76yATKHzPsE0Pz3bO0qfqh6vod18QxuiHRsnfw_at_mail.gmail.com>
Why are you messing arround with oracle internal objects? you probably will end up breaking XDB... if you don't use it, remove it altogether as it will make the upgrade faster.
Cheers
Alan.-
On Mon, Aug 1, 2011 at 12:49 PM, Lange, Kevin G <kevin.lange_at_ppoone.com>wrote:
> I get heartburn when someone says that to me. A "Clean" database
> versus a possible "Corrupt" database.
>
> Try recreating the xdb items and see if it picks up the reference and
> does away with the invalid entry.
>
>
> -----Original Message-----
> From: Sheehan, Jeremy [mailto:JEREMY.SHEEHAN_at_nexteraenergy.com]
> Sent: Monday, August 01, 2011 10:44 AM
> To: Lange, Kevin G; oracle-l_at_freelists.org
> Subject: RE: removing an object from obj$
>
> He wants a clean database. We're upgrading soon to 11g and he wants it
> pristine.
>
> Jeremy
>
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Lange, Kevin G
> Sent: Monday, August 01, 2011 11:41 AM
> To: oracle-l_at_freelists.org
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Sheehan, Jeremy
> Sent: Monday, August 01, 2011 10: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
>
>
>
> 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.
>
> --
> http://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.
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Aug 01 2011 - 11:19:25 CDT