Yes..you might need to set the buffer to some more
higher ?? but did you check on your log file or is there any bad file produce
??
They
might be data error while loading it..
-Original Message-From: Ngo BaDu
[mailto:[EMAIL PROTECTED]]Sent: Friday, June 22, 2001 3:50
PMTo:
Check your bad file and your error log file for sqlldr it should explain
what happend.
Ngo BaDu
Ngo BaDu wrote:
Dear all,
I have a text file of 70 rows. After using sql*loader to load it
into my table, I select * from my table it only show 802 rows.
Some people told me that's because of buffer.
Rubbish.
Who would like to show
me how I ought to do? Thanks you and sorry for my
What did your log say.
How many records in your bad file?
Jack
Ngo BaDu
Hi BaoDuy,
Yup I understand your problem, you can check your sqlloader control file
under what Ravinder said bad file,
Your table constraints reject your bad data because you use conventional
path,
if you use direct path bad data also will inserted into your table but your
contraints will be