Re: "Drop Public Synonym" hangs

From: <>
Date: Wed, 6 Aug 2008 05:24:40 -0700 (PDT)
Message-ID: <>

Comments embedded.
On Aug 5, 3:38 pm, wrote:
> > 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
> 1.  You can link (we are using - as correctly suggested by
> Fitz).

It wasn't a suggestion, it was a statement of fact.

> 2.  How would my synonym name help you to respond?

It may be that you've decided to choose a name for your synonym listed in V$RESERVED_WORDS; not all of those entries throw an error when used for other purposes.

I understand that this next request may appear strange, but does the following query return in a timely manner:

select distinct owner
from v$access;

If not then the issue *may* revolve around fixed object statistics; executing dbms_stats.gather_fixed_objects_stats(NULL) *may* fix your situation. Then, again, it may not fix anything. Offering advice to one who cannot, or will not, provide sufficient information about the problem is difficult, at best.

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

David Fitzjarrell Received on Wed Aug 06 2008 - 07:24:40 CDT

Original text of this message