"Drop Public Synonym" hangs

From: <BobsGTalk_at_gmail.com>
Date: Tue, 5 Aug 2008 13:04:37 -0700 (PDT)
Message-ID: <f2ad0b04-36e2-4f26-b20c-498558aebd30@25g2000hsx.googlegroups.com>

We have a public synonym on 10g (10.2.0.3.0) that uses a DB_Link to an 8i instance.

When trying to do anything with the synonym, there is no response - no error - no results - hangs for a very long time.

Attempted things done that all hang:

Select * from our_synonym;
drop public synonym our_synonym FORCE;
create or replace public synonym our_synonym for some_other_table;

Any ideas on why this is happening and what the remedy is?

Thanks
Bob Received on Tue Aug 05 2008 - 15:04:37 CDT

Original text of this message