Re: "Drop Public Synonym" hangs
Date: Wed, 6 Aug 2008 05:24:40 -0700 (PDT)
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 184.108.40.206 - as correctly suggested by
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
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