"Drop Public Synonym" hangs
Date: Tue, 5 Aug 2008 13:04:37 -0700 (PDT)
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?
Bob Received on Tue Aug 05 2008 - 15:04:37 CDT