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

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

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