ashok p
asked on
Import data from CSV to Oracle
Hi,
I am trying to import data from my csv file to new oracle table.
this is my ctrl file -
LOAD DATA
INFILE 'D:\CSV_TEST\JOBLISTCREATE DATE_25590 909174500. txt'
BADFILE 'D:\CSV_TEST\JOBLISTCREATE DATE_25590 909174500. bad'
DISCARDFILE 'D:\CSV_TEST\JOBLISTCREATE DATE_25590 909174500. dsc'
INTO TABLE "OS_DELI_ALLOC_CSV_HAFL"
APPEND
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(DACH_TXN
,
DACH_JOB_ID
,
DACH_RCV_DT
,
DACH_RCV_TIME
,
DACH_RCV_LAT
,
DACH_RCV_LON
,
DACH_REJ_RES
,
DACH_IMG_1
,
DACH_IMG_2
)
and like below statement i am executing through BAT file.
Its not getting any error. also not get the data in my oracle table .
Kindly help.
$ sqlldr HTHTEST/HTHTEST@HTHTEST CONTROL= strl_csv.ctl skip=1
I am trying to import data from my csv file to new oracle table.
this is my ctrl file -
LOAD DATA
INFILE 'D:\CSV_TEST\JOBLISTCREATE
BADFILE 'D:\CSV_TEST\JOBLISTCREATE
DISCARDFILE 'D:\CSV_TEST\JOBLISTCREATE
INTO TABLE "OS_DELI_ALLOC_CSV_HAFL"
APPEND
FIELDS TERMINATED BY ','
TRAILING NULLCOLS
(DACH_TXN
,
DACH_JOB_ID
,
DACH_RCV_DT
,
DACH_RCV_TIME
,
DACH_RCV_LAT
,
DACH_RCV_LON
,
DACH_REJ_RES
,
DACH_IMG_1
,
DACH_IMG_2
)
and like below statement i am executing through BAT file.
Its not getting any error. also not get the data in my oracle table .
Kindly help.
$ sqlldr HTHTEST/HTHTEST@HTHTEST CONTROL= strl_csv.ctl skip=1
what does your csv look like ?
ASKER
LIKE THIS
"DO_GEN-1600134852","16624 2","09/09/ 2016","11: 04:08","13 .61974000" ,"100.3913 0000",,"Si gn-D-20160 909110245. jpg","CD-2 0160909110 249.jpg"
"DO_GEN-1600135924","16624 2","09/09/ 2016","15: 45:19","13 .58309000" ,"100.2938 0000",,"Si gn-D-20160 909154043. jpg","CD-2 0160909154 048.jpg"
"DO_GEN-1600134852","16624
"DO_GEN-1600135924","16624
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.