Re: Query Help!

From: Eric de Redelijkheid <ericdere_at_xs4all.nl>
Date: Wed, 02 Nov 2005 21:13:50 +0100
Message-ID: <43691dfd$0$11078$e4fe514c@news.xs4all.nl>

Anno Domini 2-11-2005 20:06, IANAL_VISTA sprak aldus:

>"John" <Parthibban.Raja_at_gmail.com> wrote in
>news:1130958196.204187.249980_at_g47g2000cwa.googlegroups.com:
>
>
>
>> I need to view the contents of a DB2 table from Oracle SQL Plus.
>>Can someone let me know how to do this.
>>
>>
>
>What makes you think it can be done?
>
>What makes you want to use SQL*Plus to access a DB2 database?
>
>What problem are you REALLY tryin to solve?
>
>

You might want to look into Heterogeneous Connectivity or transparent gateways. Assuming you want to access both Oracle databases and DB2 through a databaselink.

It used to be possible to directly access an ODBC datasource with SQL*Plus 8.0.6 from Developer.

From Metalink:

Solution Description

In order to connect SQL*Plus to a non-oracle database through the Oracle Open Client Adapter, (OCA), you will need to use SQL*PLUS 8.0.6. As of March 1, 2001, there is currently no version of the OCA for 8i.

Explanation

The OCA is provided for Oracle Forms Developer and Oracle Reports Developer to connect and run Forms and Reports applications against non-oracle databases. The current shipping version of these products is 6i, which is built to run under the 8.0.6 client. You will need to use this version of the client in order to make this work. Received on Wed Nov 02 2005 - 14:13:50 CST