Re: anybody know of 8i bug with database links?

From: Giorgos Tsiamitas <gtsiam_at_gmx.net>
Date: Wed, 16 May 2001 13:36:41 GMT
Message-ID: <JnvM6.108$MW2.2862@nreader1.kpnqwest.net>

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.

--
Giorgos
"mel" <jmel_at_mailnews.com> wrote in message
news:3b017830$0$21774$45beb828_at_newscene.com...


> we were told the following by oracle dba

>

> "a bug in Oracle 8i causes intermittent incorrect results

> when using Databse links"

>

> is this true?  anybody has info on it?

Received on Wed May 16 2001 - 08:36:41 CDT