Thank you. I am using SQL PLUS Version 10.1.0. How do I know whether
the
Heterogeneous connectivity or transparent gateways are configured or
not?
Eric de Redelijkheid wrote:
> 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 - 15:52:42 CST
