Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: anybody know of 8i bug with database links?
do u know what a remote colocated join is, there is a bug involving links that refers to it.
In article <JnvM6.108$MW2.2862_at_nreader1.kpnqwest.net>, "Giorgos Tsiamitas"
<gtsiam_at_gmx.net> wrote:
>I had this problem some months ago with Oracle 8.1.6.0.0 on HP-UX. Sometimes
>I got incorrect results, sometimes ORA-600 errors.
>
>That's Oracle bug# 1281200 : "Executing a query joining local tables and
>tables accross dblink yields incorrect results - compared to all tables
>being local. CBO returning incorrect number of rows."
>
>The workaround is to add the following line in init.ora (it will make CBO to
>behave as in Oracle 8.0.x versions):
>event=10176 trace name context forever, level 10, 10127 trace name context
>forever, level 10
>
>Patch 8.1.6.2.0 also solves the problem.
>
Received on Wed May 16 2001 - 12:20:11 CDT