Re: Linked table Doesn't show data
From: gazzag <gareth_at_jamms.org>
Date: Thu, 22 Jan 2009 08:58:42 -0800 (PST)
Message-ID: <260489a9-e556-4485-a31a-91128c7cb3a2_at_g39g2000pri.googlegroups.com>
On 19 Jan, 23:22, CenturionX <darwinbaldr..._at_gmail.com> wrote:
> I'm working in a database Oracle 10.2.0.4.0 where there is created a
> link to a second database Oracle 8.1.6.0.0.
>
> There is a synonym created referencing a table in the second database.
> The link is OK but when i query the table it doesn't retrieve any
> data.
>
> How could it be solved??
>
> Thanks again everybody.
Date: Thu, 22 Jan 2009 08:58:42 -0800 (PST)
Message-ID: <260489a9-e556-4485-a31a-91128c7cb3a2_at_g39g2000pri.googlegroups.com>
On 19 Jan, 23:22, CenturionX <darwinbaldr..._at_gmail.com> wrote:
> I'm working in a database Oracle 10.2.0.4.0 where there is created a
> link to a second database Oracle 8.1.6.0.0.
>
> There is a synonym created referencing a table in the second database.
> The link is OK but when i query the table it doesn't retrieve any
> data.
>
> How could it be solved??
>
> Thanks again everybody.
Can you not upgrade the 8.1.6.0 database? If you really need to stick with 8i, version 8.1.7.4 was the terminal release and that's still pretty old!
HTH -g Received on Thu Jan 22 2009 - 10:58:42 CST