I have been running sqlldr on Oracle 11g using this command:
sqlldr myUser/myPWD@myCONN control='d:/sqlload/new/te
But I just noticed that out of the 62K records of test1.txt, the sqlldr is only importing first 48K records. It is ignoring the remaining records of test1.txt. It is not the data issue because the same data get imported if those are at the 1st part of the test1.txt file.
Is bindsize = 2000000 has got to do anything with this?
OPTIONS (SKIP = 1 , bindsize = 2000000)
INTO TABLE myTab1
fields terminated by X'09'
f2 DATE 'yyyy-mm-dd hh24:mi:ss',
f3 DATE 'yyyy-mm-dd hh24:mi:ss',