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