Prev: Can this be done with a trigger?
Next: Oracle Spatial Selecting Overlaps returning no results (whenit should)?
From: BobsGTalk on 5 Aug 2008 16:04

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


From: Shakespeare on 5 Aug 2008 16:15

<BobsGTalk(a)gmail.com> schreef in bericht
news:f2ad0b04-36e2-4f26-b20c-498558aebd30(a)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


From: fitzjarrell on 5 Aug 2008 16:28
On Aug 5, 3:15 pm, "Shakespeare" <what...(a)xs4all.nl> wrote:
> <BobsGT...(a)gmail.com> schreef in berichtnews:f2ad0b04-36e2-4f26-b20c-498558aebd30(a)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
From: BobsGTalk on 5 Aug 2008 16:38

> 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).
2. How would my synonym name help you to respond?
3. Maybe I am cranky now (late afternoon) - but why did you bother
responding with no info?
From: Shakespeare on 6 Aug 2008 04:08

<BobsGTalk(a)gmail.com> schreef in bericht
news:30a5643e-b5f1-4d4e-877d-c2356b33f1af(a)m44g2000hsc.googlegroups.com...
>
>> 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).
> 2. How would my synonym name help you to respond?
> 3. Maybe I am cranky now (late afternoon) - but why did you bother
> responding with no info?


1) I told you I was not sure, and Fitz corrected it correctly. If you had
bothered to state your version in your question, I might have looked it up
before answering.
2) You would be surprised how many people tried to drop a synonym which
appeared to be a reserved word or something alike... and put a question on a
forum
3) OK. I'll put you on my ignore list if you like

Shakespeare


 |  Next  |  Last
Pages: 1 2
Prev: Can this be done with a trigger?
Next: Oracle Spatial Selecting Overlaps returning no results (whenit should)?