Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SV: Automatic import of a text file into an Oracle database
Thanks for your quick response. I am aware of the sqlloader but i want to do
some extensive checking of the data on the file. Is sqlloader userful in
this setting?
Lars
:-))
konsultant_1 - konsultancIT.pl <konsultant_1_at_konsultancIT.pl> skrev i
meldingsnyheter:3EEF1579.6000203_at_konsultancIT.pl...
> Lars Mollerup wrote:
> > Hello folks!
> >
> > here is my question:
> >
> > What is the best way to get data from a character delimited text file
into
> > an oracle database once a day. It should import it automatically and
check
> > the data before inserting values into tables?
> >
> > (I am thinking of making a VB program to do this but could it be be
done by
> > scheduling a
> > stored procedure or some other Oracle specific way?)
> >
> >
> > TIA
> >
> > Lars Mollerup
> > NIVA, Norway
> >
> >
>
> SQLOADER
>
> --
>
> www.konsultancIT.pl
> Oracle&MS-SQL consulting
>
Received on Tue Jun 17 2003 - 08:20:24 CDT