Re: Can I link to outside tables/files in Oracle?
Date: Thu, 11 Jan 2001 13:44:29 +0100
Message-ID: <93kd29$mcg$1_at_papyrus.erlm.siemens.de>
If you are using Oracle 8i the new "heterogeneous services" allow that. For details refer to the online documentation.
Klaus
<dtu16_at_my-deja.com> schrieb in im Newsbeitrag:
93ihei$f97$1_at_nnrp1.deja.com...
> We need to create an Oracle database with data
> from various sources. i.e., the source data is in
> different formats such as text file (fixed
> width), Excel files, dBASE files and Access
> tables as well as other Oracle tables. Is there a
> way that we can link to those data sources in
> Oracle database so that we view those as they
> were Oracle tables, without actually
> moving/copying the same data over in Oracle
> database? Like in MS Access, one can link to
> outside files/tables. Is there such utility
> program available for Oracle? Since our source
> data are updated all the time, it would save us a
> lot time and space if we don't have to duplicate
> the same data in Oracle in order to use them. Any
> help is greatly appreciated.
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 11 2001 - 13:44:29 CET