Hi All,
I am new to sqlldr and trying to Insert a file in to oracle db but i constantly get an error access is denied.
Can anyone help me out on this.
This is my .CTL file
LOAD DATA
INFILE "X:\VMI\test.csv"
INSERT into table DETAIL
REPLACE
fields terminated by ','
(ID,NAME,ADDRESS,CITY,MOBILE);
.bat or cmd query
X:\VMI>sqlldr upi/upi DATA=X:\VMI\test.csv CONTROL=Insert.ctl LOG=Insert.log