RE: so get a load of this - venting on support

From: Goulet, Richard <>
Date: Wed, 2 Nov 2011 12:47:55 +0000
Message-ID: <>


        That would match with another I've seen. Having a problem with the system tablespace. JR DBA type (straight out of boot camp) question to OTS, "Is it possible to drop and recreate the system tablespace?". OTS Answer, "Yes". JR DBA "drop tablespace system;". DB Answers "Tablespace dropped, ORA-00600.........".

        Would have been nice if the analyst had said, yes but.....

Richard Goulet
Senior Oracle DBA/Na Team Leader

-----Original Message-----

From: [] On Behalf Of Sent: Tuesday, November 01, 2011 2:33 PM To:
Subject: so get a load of this - venting on support

Content-Type: text/plain; charset="US-ASCII" a SR is opened due to an issue with dbms_metadata.get_ddl.

Solution: drop and recreate sys.dual,

so the junior DBA does as said and now can't recreate due to ORA-1775 looping chain of synonyms. I'm biting my tongue to not give support a real piece of my mind, oh and this was to an escalated individual.

He comes and sees me to get it fixed, google comes to rescue on how to fix it but geez support, REALLY, DROP DUAL????



-- Received on Wed Nov 02 2011 - 07:47:55 CDT

Original text of this message