Re: "Drop Public Synonym" hangs
Date: Tue, 5 Aug 2008 22:15:49 +0200
<BobsGTalk_at_gmail.com> schreef in bericht
> 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?
Maybe if you tell us the exact name of our_synonym.
IIRC, you can't db-link from 10g to 8i directly (not sure about that though)
Shakespeare Received on Tue Aug 05 2008 - 15:15:49 CDT