Re: "Drop Public Synonym" hangs

<BobsGTalk_at_gmail.com> schreef in bericht news:6cde2dda-724a-42cc-ad2c-7db339428dfd_at_k30g2000hse.googlegroups.com...
>
>> > 3. Maybe I am cranky now (late afternoon) - but why did you bother
>> > responding with no info?
>>
>> Possibly because you provided so little with which to work in your
>> original post and in this follow-up.
>
>
> Okay - sorry for being cranky.

Apologies granted.

> Anyway - the problem is this - we have
> circular links - a public synonym on both 8i and 10g pointing to each
> other through reverse database links. Now, I just got on this project
> and I did not set it up. However, a post on the internet from "Neil
> Jarvis" indicates that in this situation, once the synonym is used
> through the link, it will just hang every other DDL/DML statement
> related to the public synonym and not return with an error or
> anything. This is what we are seeing and he provides a solution which
> I am going to try.
>
> See link "Bugs, Quirks and Features" on the following link (it is a
> word document).
> http://www.go-faster.co.uk/bugs.htm

Interesting link, thanks.

Shakespeare Received on Wed Aug 06 2008 - 10:30:48 CDT