so get a load of this - venting on support

  • From: TESTAJ3@xxxxxxxxxxxxxx
  • To: Oracle-L@xxxxxxxxxxxxx
  • Date: Tue, 1 Nov 2011 14:32:54 -0400

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




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


Other related posts: