Re: Importing CSV's to Oracle

rsmith_at_serck-controls.co.uk (Russell Smith) wrote in message news:<f191bfd4.0201080259.a4cd811_at_posting.google.com>...
> I have alot (3gb+) of CSV files to import into oracle, there are
> however a few problems. The data contains dates, in differing
> formats;
>
> 9/10/98 0:11
>
> or
>
> 8-SEP-1998 22:17:00
>
>
> I have used the following but need to be able to do both types at once
> (i don't want to have to pre-process the data before import), any
> suggestions?
>
> LOAD DATA
> INFILE 'C:\test.CSV'
> APPEND
> INTO TABLE SCXDOWNLOAD.HISDAT_A
> FIELDS TERMINATED BY ","
> (cbarow ,
> cbagranule,
> cbarecord,
> cbatime DATE "dd-MON-yyyy/hh24:mi:ss",
> token,
> hisflt,
> status,
> alarm_flag,
> modify_flag,
> insert_flag)
>
> Many thanks
>
> Russell Smith
> Software Projects

Can you do anything with altering the nls_date_format and nls_date_language for your session ? Received on Tue Jan 08 2002 - 15:08:55 CET