Hai Everyone,
I want to load multiple files in to one table by using infile comand. one file its loading and if i use multiple file names also its loading.
But i want to load all the files what ever its there in a folder and i dont want to mention any file name.
below is the control file command what i am using.
options(skip=1)
load data
infile 'W:\FTPUpdates\OUTFiles\*.csv'
BADFILE 'W:\FTPUpdates\Logs\ControlLogs\sqlldrbad1.bad'
DISCARDFILE 'W:\FTPUpdates\Logs\ControlLogs\LTO\sqlldrdiscard1.DIS'
APPEND
into table GW.UPLOAD_RAW_DATA
fields terminated by ','
trailing nullcols
(
LTO_ITH_ID INTEGER EXTERNAL,
LTO_ITEM_ID ,
LTO_QTY ,
FRM_STORE ,
TO_STORE ,
STK_CREATE_DATE SYSDATE
)
Please help me to load all the files which its there in OUT folder. I dont want to mention multiple file names in control file.
Thanks,
Sankar.