troubleshooting Question

Oracle sqlldr question

Avatar of toooki
toooki asked on
DatabasesOracle Database
24 Comments2 Solutions5968 ViewsLast Modified:
I have been running sqlldr on Oracle 11g using this command:

sqlldr myUser/myPWD@myCONN control='d:/sqlload/new/test/loader1.ctl'

It works.

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)
load data
 infile 'd:/sqlload/new/test/test1.txt'
 TRUNCATE
 INTO TABLE myTab1
 fields terminated by X'09'
 TRAILING NULLCOLS
(
f1, 
f2 DATE 'yyyy-mm-dd hh24:mi:ss',  
f3 DATE 'yyyy-mm-dd hh24:mi:ss',
f4, 
f5
)
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 2 Answers and 24 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 24 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros