Re: "Drop Public Synonym" hangs
From: <BobsGTalk_at_gmail.com>
Date: Wed, 6 Aug 2008 12:19:28 -0700 (PDT)
Message-ID: <059bd13b-2bcc-447c-946e-adfb20faf580@b1g2000hsg.googlegroups.com>
Date: Wed, 6 Aug 2008 12:19:28 -0700 (PDT)
Message-ID: <059bd13b-2bcc-447c-946e-adfb20faf580@b1g2000hsg.googlegroups.com>
The suggestion in the link worked.
After alerting developers to beware, I killed all sessions that were
coming through a DB_Link
select * from v$session where username='Our_Database_Link';
Then I was able to drop the public synonym that was causing all the trouble and recreate the synonyms properly.
Everyone is happy and up and running.
Bob Received on Wed Aug 06 2008 - 14:19:28 CDT