OraFAQ Forum: Server Utilities » Commit point reached

Home » RDBMS Server » Server Utilities » Commit point reached - logical record count 64 (Sqlldr, version =10.2.0.1.0, Windows XP)

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

Commit point reached - logical record count 64 [message #309541]

Thu, 27 March 2008 17:06

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 1473 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

ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN

Junior Member

I am attaching csv file

Attachment: data.csv
(Size: 9.43KB, Downloaded 1425 times)

Report message to a moderator

Re: Commit point reached - logical record count 64 [message #309544 is a reply to message #309542]

Thu, 27 March 2008 17:26

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.

Report message to a moderator

Re: Commit point reached - logical record count 64 [message #309545 is a reply to message #309541]

Thu, 27 March 2008 17:26

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

Senior Member
Account Moderator

>> i get the error:
Why do you think this is an error?

Report message to a moderator

Re: Commit point reached - logical record count 64 [message #309546 is a reply to message #309545]

Thu, 27 March 2008 17:36

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 1420 times)

Report message to a moderator

Re: Commit point reached - logical record count 64 [message #309547 is a reply to message #309546]

Thu, 27 March 2008 17:43

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

Senior Member
Account Moderator

>> FillType varchar2(20),

scott@9i > select length('Non inventory Purchase') from dual;

LENGTH('NONINVENTORYPURCHASE')
------------------------------
                            22

Report message to a moderator

Re: Commit point reached - logical record count 64 [message #309548 is a reply to message #309547]

Thu, 27 March 2008 17:48

ambreen.fatima
Messages: 15
Registered: February 2007
Location: PAKISTAN

Junior Member

It worked out!
Thanks a lot.
i really appreciate your help.

regards,

Report message to a moderator

Previous Topic:	Problem whit nulls and sql loader
Next Topic:	UTL_FILE question

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 17 05:51:22 CDT 2024