Importing CSV's to Oracle

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 Received on Tue Jan 08 2002 - 11:59:01 CET