Re: "Drop Public Synonym" hangs

From: <>
Date: Wed, 6 Aug 2008 12:19:28 -0700 (PDT)
Message-ID: <>

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

Original text of this message