Importing CSV's to Oracle
From: Russell Smith <rsmith_at_serck-controls.co.uk>
Date: 8 Jan 2002 02:59:01 -0800
Message-ID: <f191bfd4.0201080259.a4cd811_at_posting.google.com>
Date: 8 Jan 2002 02:59:01 -0800
Message-ID: <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;
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