Re: Importing ASCII file(s) to Oracle8
From: Alex Filonov <afilonov_at_yahoo.com>
Date: 5 Jun 2002 10:55:55 -0700
Message-ID: <336da121.0206050955.524364f9_at_posting.google.com>
Date: 5 Jun 2002 10:55:55 -0700
Message-ID: <336da121.0206050955.524364f9_at_posting.google.com>
"Tomo" <tomislav_at_europatrade.hr> wrote in message news:<adkft3$9sif$1_at_as201.hinet.hr>...
> How complex is it to create an import query that imports ASCII files/tables
> with defined columns to an Oracle 8 database table?
> I've been told that it is a time-consuming job.
It's easy. There is utility, sqlloader. There is documentation about it in Server Utilities Guide. In most cases you can use one of the examples in this document. And you don't need a query to do that. Just a small control file.
>
> Thanks,
>
> Tom
Received on Wed Jun 05 2002 - 19:55:55 CEST