"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>
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