OraFAQ Forum: Server Utilities » sqlldr dose not load full data

Home » RDBMS Server » Server Utilities » sqlldr dose not load full data

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

sqlldr dose not load full data [message #71711]

Thu, 26 December 2002 02:26

soheail
Messages: 8
Registered: December 2002

Junior Member

Dear sir,
i am trying to load data through sqlldr. my dat file contains 5000 data but when i run sqlldr then insert 1200 data in my table.
pls reply me.

soheail

Report message to a moderator

Re: sqlldr dose not load full data [message #71714 is a reply to message #71711]

Thu, 26 December 2002 07:00

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

check your logfile to see why it is not loading all the data.
and pls post the exact message

Report message to a moderator

Re: sqlldr dose not load full data [message #71720 is a reply to message #71711]

Fri, 27 December 2002 21:08

soheail
Messages: 8
Registered: December 2002

Junior Member

Dir sir,
My main problem is in error size. Default error size is 50.after increasing the error size it is work properly.

Can I load data through PL/SQL?

Thanks
soheail

Report message to a moderator