Re: Flat file to Oracle

From: Donovan R. <mdonovan_at_hotmail.com>
Date: Tue, 18 Feb 2003 21:54:58 -0500
Message-ID: <9as55v8bqngc91thrp1qvfkjin9rlso03s_at_4ax.com>


use utl_file instead sqldr

http://download-west.oracle.com/docs/cd/A87860_01/doc/appdev.817/a76936/utl_file.htm#998101

On Tue, 18 Feb 2003 05:17:53 GMT, "Gavirel" <azvzq_at_yahoo.com> wrote:

>Hi all,
>
>Recently, I need to import data from a lot of flat files to Oracle. And it
>will need to be done weekly. I am planning to use sqlldr. But the problem is
>these flat files have different number of fields. So, I am wondering does
>anyone know a way to generate control file and the sql file from the flat
>file?
>
>thank you so much
>
>G
>
  Received on Wed Feb 19 2003 - 03:54:58 CET

Original text of this message