so get a load of this - venting on support

From: <TESTAJ3_at_nationwide.com>
Date: Tue, 1 Nov 2011 14:32:54 -0400
Message-ID: <OF2A6B14E1.1802EC6C-ON8525793B.0065940A-8525793B.0065E58E_at_lnotes-gw.ent.nwie.net>

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????

joe

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

Received on Tue Nov 01 2011 - 13:32:54 CDT