Re: "Drop Public Synonym" hangs

<BobsGTalk_at_gmail.com> schreef in bericht news:f2ad0b04-36e2-4f26-b20c-498558aebd30_at_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
>
>

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