Re: removing an object from obj$
From: David Fitzjarrell <oratune_at_yahoo.com>
Date: Mon, 1 Aug 2011 12:42:53 -0700 (PDT)
Message-ID: <1312227773.86419.YahooMailNeo_at_web65406.mail.ac4.yahoo.com>
Sounds more like� hunting flies with a cannon. David Fitzjarrell From: "Goulet, Richard" <Richard.Goulet_at_parexel.com> To: "JEREMY.SHEEHAN_at_nexteraenergy.com" <JEREMY.SHEEHAN_at_nexteraenergy.com>; "oracle-l_at_freelists.org" <oracle-l@freelists.org> Sent: Monday, August 1, 2011 12:33 PM 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
Date: Mon, 1 Aug 2011 12:42:53 -0700 (PDT)
Message-ID: <1312227773.86419.YahooMailNeo_at_web65406.mail.ac4.yahoo.com>
Sounds more like� hunting flies with a cannon. David Fitzjarrell From: "Goulet, Richard" <Richard.Goulet_at_parexel.com> To: "JEREMY.SHEEHAN_at_nexteraenergy.com" <JEREMY.SHEEHAN_at_nexteraenergy.com>; "oracle-l_at_freelists.org" <oracle-l@freelists.org> Sent: Monday, August 1, 2011 12:33 PM 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-lReceived on Mon Aug 01 2011 - 14:42:53 CDT