OraFAQ Forum: Server Utilities » SQL Loader Error message

Home » RDBMS Server » Server Utilities » SQL Loader Error message

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

SQL Loader Error message [message #73233]

Fri, 05 March 2004 07:19

Farhat A.
Messages: 6
Registered: February 2004

Junior Member

I try to append or to insert data from text file to an oracle table using SQLLDR73
the result didnt append all records and I get message called as this :

commit pint reahced - logical record count 64
commit pint reahced - logical record count 128
commit pint reahced - logical record count 192
commit pint reahced - logical record count 256
commit pint reahced - logical record count 320
SQL*Loader-605: Non-data dependent ORACLE error coccured -- load discontinued.
commit pint reahced - logical record count 384

thanking your assistance

Regards

Report message to a moderator

Re: SQL Loader Error message [message #73235 is a reply to message #73233]

Fri, 05 March 2004 10:01

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

Senior Member
Account Moderator

some data error..
post the logfile...we can give a try..

Report message to a moderator

Re: SQL Loader Error message [message #74202 is a reply to message #73235]

Wed, 06 October 2004 04:41

Bosson
Messages: 1
Registered: October 2004

Junior Member

Could you give me explication about this error:
SQL*Loader-522: lfiopn failed for file

Thank for your help

T.Bosson

Report message to a moderator

Re: SQL Loader Error message [message #74203 is a reply to message #74202]

Wed, 06 October 2004 06:20

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

Senior Member
Account Moderator

Make sure you have the correct Operating System priviliges.
try giving a logfile .
if you can , you are all set.
Else check OS privs.

Report message to a moderator

Previous Topic:	Tablespace Point-in-Time Recovery
Next Topic:	sqlplus connections logged where?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jul 01 10:01:17 CDT 2024