RE: removing an object from obj$

  • From: Marco Gralike <Marco.Gralike@xxxxxxx>
  • To: "cicciuxdba@xxxxxxxxx" <cicciuxdba@xxxxxxxxx>, "kevin.lange@xxxxxxxxxx" <kevin.lange@xxxxxxxxxx>
  • Date: Mon, 1 Aug 2011 18:46:04 +0200

In this rare case, also as suggested by Support (the only exception when to do 
this), this valid.

The XDB environment does not have any relational enforced PK/FK and consists of 
standalone tables. "Relations" are created internally via code (internal 
packages and functions etc). Some objects are "joined" via these standalone 
tables and SYS base tables and it can occur that objects in those very early 
releases of XMLDB (like the 9.2.x versions) will cleaned in the XDB environment 
but not in the SYS base tables. So it can occur that the XDB objects is gone 
but still has residu in the SYS environment. AFAIK most of these issues have 
been solved in 10.x versions of the database.

Therefore, this delete is justified due to the circumstance PLUS the advise 
given by Oracle Support via a Service Request. This should be the ONLY 
exception of doing something like this: as requested by SUPPORT.


 *
Stop the listener
 *
Stop the database
 *
Start the database in restricted mode
 *
Login via SQL*Plus as SYSDBA
 *
Delete the object via SYS (be absolutely sure it is the correct DELETE!).
 *
Commit.
 *
Do not do anything else.
 *
Stop the database.
 *
Start the database normally
 *
Check
 *
Start the listener

M.

________________________________
Van: oracle-l-bounce@xxxxxxxxxxxxx [oracle-l-bounce@xxxxxxxxxxxxx] namens 
Guillermo Alan Bort [cicciuxdba@xxxxxxxxx]
Verzonden: maandag 1 augustus 2011 18:19
Aan: kevin.lange@xxxxxxxxxx
CC: oracle-l@xxxxxxxxxxxxx
Onderwerp: Re: removing an object from obj$

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@xxxxxxxxxx<mailto:kevin.lange@xxxxxxxxxx>> 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@xxxxxxxxxxxxxxxxx<mailto:JEREMY.SHEEHAN@xxxxxxxxxxxxxxxxx>]
Sent: Monday, August 01, 2011 10:44 AM
To: Lange, Kevin G; oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On 
Behalf Of Lange, Kevin G
Sent: Monday, August 01, 2011 11:41 AM
To: oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>] On 
Behalf Of Sheehan, Jeremy
Sent: Monday, August 01, 2011 10:36 AM
To: oracle-l@xxxxxxxxxxxxx<mailto: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



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.

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

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

Other related posts:

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