RE: removing an object from obj$

  • From: "Mark W. Farnham" <mwf@xxxxxxxx>
  • To: <Marco.Gralike@xxxxxxx>, <cicciuxdba@xxxxxxxxx>, <kevin.lange@xxxxxxxxxx>
  • Date: Mon, 1 Aug 2011 14:47:11 -0400

By the way, unless what Marco noted in the previous note on the thread is
your exact situation, then if your boss wants a "CLEAN" 11g database,
consider what it would cost to build a new empty 11g database and move the
data in (without ever creating the invalid XDB object.) Hey, even if the
situation Marco described is your situation, notice his carefully cautionary
writing about it.

 

Depending on what is in your database this can range from trivially simple
to arbitrarily complex. Depending on the size and whether the bulk of your
tablespaces can be easily transported it can be an effort of short to
impractically long duration compared to your operational requirements.

 

If yours turns out to be simple and short, I'd think seriously about laying
down a fresh clean empty (well rapid installed image copy, but no user
data), creating your users and figuring out the best way to load your data.

 

Notice those two scales are often unrelated: Completely simple sets of
tables can be huge, and very complex sets of tables can be very small.

 

I'd rather build a new container for something big and simple than complex
and small, as long as the window allowed to move the big simple thing is
generous, because it is a lot easier to be pretty doggone sure you got it
right. (Except for the one missing invalid object, in your case, which you
want to miss.)

 

Messing with direct sql on dictionary objects is not "plan A" for having a
"clean" database. I would rather have some invalid objects that the database
knows about which are artifacts of normal commands than a production
database that has been tampered with.

 

mwf

 

From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Marco Gralike
Sent: Monday, August 01, 2011 12:47 PM
To: cicciuxdba@xxxxxxxxx; kevin.lange@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: RE: removing an object from obj$

 

BTW 

 

You can't remove it in 11g anymore, due to the fact that it is a core part
of the database and among others takes care of...

 

Dependancies exists for, for example:

 

UTL_MAIL, UTL_FILE, UTL_TCP, UTL_HTTP

The PL/SQL Gateway

Database Vault

DB Console

DBMS_METADATA

 

...

 

 

  _____  

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>
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]
Sent: Monday, August 01, 2011 10:44 AM
To: Lange, Kevin G; 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] On Behalf Of Lange, Kevin G
Sent: Monday, August 01, 2011 11:41 AM
To: 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] On Behalf Of Sheehan, Jeremy
Sent: Monday, August 01, 2011 10: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



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