Re: Oracle heterogeneous data access under UNIX

Daniel Morgan <dmorgan_at_exesolutions.com> wrote in message news:<3D5970DA.1077ED84_at_exesolutions.com>...
> Answers interspersed below:
>
> Jim wrote:
>
> > Is there anyway that Oracle under UNIX allows for querying flat text
> > file (well delimited, either comma separated or fixed character
> > fields) as if they were tables. I don't want to load the data into
> > Oracle, but rather query the files as if they were external tables.
>
> With 9i
>

Also with 8.1.7. All you need are the following

• ODBC for the flat file on Unix
• Set up Heterogeneous services, with a database link pointing to the ODBC driver

> > Also, can Oracle link multiple non related database servers: i.e.
> > MSSQL Server, Ingres, Sybase, MySQL and query all these external
> > sources from within Oracle by creating some sort of link between
> > Oracle and the external world?
>
> With Oracle Transparent Gateway products. Also with Java and C.
>

Also with Heterogeneous services - again you can get an ODBC driver for things like MSSQL 2000, and set up Heterogeneous services.

You can download the documentation (part number A88714-01) from the site - this explains in detail what to do.

Colin McPherson Received on Wed Aug 14 2002 - 05:01:21 CDT