Re: "Drop Public Synonym" hangs

Comments embedded.
On Aug 5, 3:38�pm, BobsGT..._at_gmail.com 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 8.1.7.4 - 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