Re: Flat file to Oracle
Date: Wed, 19 Feb 2003 23:29:21 GMT
Message-ID: <lrU4a.17857$Zr%.6461_at_news01.bloor.is.net.cable.rogers.com>
Thank you for answering my question. But the problem is that I have to call
a system function to retrieve those files. that's why I need to write some
script to generate the control file from the returned flat files, so is it
still possible to use util_file. Thanks.
"Donovan R." <mdonovan_at_hotmail.com> wrote in message
news: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 Thu Feb 20 2003 - 00:29:21 CET