Re: "Drop Public Synonym" hangs

On Aug 5, 3:15 pm, "Shakespeare" <what..._at_xs4all.nl> wrote:
> <BobsGT..._at_gmail.com> schreef in berichtnews: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- Hide quoted text -
>
> - Show quoted text -

You can if the 8i is 8.1.7.4; nothing earlier than that, though.

David Fitzjarrell Received on Tue Aug 05 2008 - 15:28:26 CDT