Re: Selects via DB Links - Special Tuning Considerations

> > You might run into problems since version 8 is no longer supported.
>
> That is the least of his worries, as 8.0.x will not 'converse' with 10g
> of any sort via SQL*net. Not directly, anyway. Such a configuration
> requires an intermediate version such as 9.0.1 or 9.2.0 to act as a
> 'gateway'. The earliest release which will connect to 10g directly is
> 8.1.7.x.
>
> > Depending on your applications, this change could generate a lot of
network
> > traffic, and make your queries run slower.
> >
>
> Yes, his queries will run so slowly as to return no results since there
> will essentially be *no* network traffic generated between 8.0.6 and
> 10.2.0 because the SQL*Net versions are incompatible.
>

Actually I did not do any research on whether it will work. I was just pointing out what issues he might have if it does work. That was precisely OP's concern.

> > Oracle docs are all over the internet, not just on tahiti.
>
> Funny you didn't find this information in those docs ....
>

Apparently, he has made it work. So don't try to get ahead of yourself here. Received on Tue Dec 06 2005 - 14:15:49 CST