Home » RDBMS Server » Server Utilities » Commit point reached - logical record count 64 (Sqlldr, version =10.2.0.1.0, Windows XP)
Commit point reached - logical record count 64 [message #309541] Thu, 27 March 2008 17:06 Go to next message
ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN
Junior Member
When I use sqlldr i get the error:

Commit point reached - logical record count 64
Commit point reached - logical record count 128
Commit point reached - logical record count 180

My command was: sqlldr control='c:\ord.ctl' userid=XXX/YYY@ZZZ

CREATE TABLE O_D (
OrderType varchar2(10),
SalesTerms varchar2(30),
PayTerms varchar2(20),
FillType varchar2(20),
LineType varchar2(10)
) tablespace user_data

[Edit MC: connection string removed for confidentiality following OP request]
  • Attachment: ord.ctl
    (Size: 0.15KB, Downloaded 425 times)

[Updated on: Tue, 22 July 2008 13:44] by Moderator

Report message to a moderator

Re: Commit point reached - logical record count 64 [message #309542 is a reply to message #309541] Thu, 27 March 2008 17:07 Go to previous messageGo to next message
ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN
Junior Member
I am attaching csv file
  • Attachment: data.csv
    (Size: 9.43KB, Downloaded 396 times)
Re: Commit point reached - logical record count 64 [message #309544 is a reply to message #309542] Thu, 27 March 2008 17:26 Go to previous messageGo to next message
Tafer
Messages: 64
Registered: July 2005
Location: Here!
Member
Are you sure that it is an error?

Check the destination table (O_D), it looks like the data has been inserted perfectly.
Re: Commit point reached - logical record count 64 [message #309545 is a reply to message #309541] Thu, 27 March 2008 17:26 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> i get the error:
Why do you think this is an error?
Re: Commit point reached - logical record count 64 [message #309546 is a reply to message #309545] Thu, 27 March 2008 17:36 Go to previous messageGo to next message
ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN
Junior Member
It does not inserts the records containing 'Non inventory Purchase'

e.g

Invoice ,Calc Dlvd,10 Days,Non inventory Purchase,Misc

I am attaching bad file.
  • Attachment: data.bad
    (Size: 2.03KB, Downloaded 404 times)
Re: Commit point reached - logical record count 64 [message #309547 is a reply to message #309546] Thu, 27 March 2008 17:43 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> FillType varchar2(20),
scott@9i > select length('Non inventory Purchase') from dual;

LENGTH('NONINVENTORYPURCHASE')
------------------------------
                            22
Re: Commit point reached - logical record count 64 [message #309548 is a reply to message #309547] Thu, 27 March 2008 17:48 Go to previous message
ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN
Junior Member
It worked out!
Thanks a lot.
i really appreciate your help.


regards,
Previous Topic: Problem whit nulls and sql loader
Next Topic: UTL_FILE question
Goto Forum:
  


Current Time: Wed Dec 07 22:13:37 CST 2016

Total time taken to generate the page: 0.05496 seconds