Re: Oracle heterogeneous data access under UNIX

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, 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.

> MSSQL 2000 can do this, and now I am trying to achieve the same
> using Oracle under UNIX.

Daniel Morgan Received on Tue Aug 13 2002 - 15:49:32 CDT