Re: Oracle says there is bug using remote colacated joins. Anybody know what they are

This came in from Steve Adams IXORA mailing list today (coincidence?) I hope Steve will forgive me for the outright quoting (though I do recommend you join his mailing list)... ;-)

>If a distributed query joins two tables from the same remote database, then
 the
>join may be performed by the slave session in the remote instance. If so,
 that
>join is said to be a collocated join.
 

>@ Regards,
>@ Steve Adams
>@ http://www.ixora.com.au/
>@ http://www.christianity.net.au/

"Mark Townsend" <markbtownsend_at_home.com> wrote in message news:B729D8C9.B267%markbtownsend_at_home.com...
> in article 3b03bc90$0$12267$45beb828_at_newscene.com, sdfsd at sdfes_at_dsf.com
> wrote on 5/17/01 5:00 AM:
>
> > Oracle says there is bug using remote colacated joins over a remote
 dblink in
> > 8.1.5 and above.
> >
> > anybody have any idea of what a remote colocated join is?
>
> Without a bug number to look it up, I'm only guessing, but I'm pretty sure
> it means that the two (or more) tables involved in the join are both in
 the
> same remote database. There were some changes in the way these joins are
> shipped in 8.1.5. If you think you are running into a problem with this, a
> possible work around may be to create a view on the remote database that
> does the join and then access the view across the dblink.
>
Received on Fri May 18 2001 - 05:17:11 CDT