OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » SQL Loader (12c)

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

SQL Loader [message #683583]

Thu, 04 February 2021 01:29

deepakdot
Messages: 93
Registered: July 2015

Member

In SQL Loader (sqlldr) , Lets say I have 100 rows in the data files and there are 10 bad row. So after loading I am getting proper log says 90 rows loaded and 10 rows failed. And I am getting the bad file for those 10 rows also. All good here.

But Is there a way, when any one row from the datafile failed, then all the 100 rows of that data file rollback? Nothing should get loaded to the database.

Regards,
Deepak

Report message to a moderator

Re: SQL Loader [message #683585 is a reply to message #683583]

Thu, 04 February 2021 02:29

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Have a look at SQL*Loader parameters: "errors=0" and "rows" and "bindsize" large enough if you use the conventional path.

Report message to a moderator

Re: SQL Loader [message #683651 is a reply to message #683585]

Wed, 10 February 2021 07:22

deepakdot
Messages: 93
Registered: July 2015

Member

Mike,

ERRORS=0 does not help. still it loads the good data. I am using very large bind size also.

Report message to a moderator

Re: SQL Loader [message #683652 is a reply to message #683651]

Wed, 10 February 2021 07:42

Michel Cadot
Messages: 68757
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Post command and log and don't forget to use code tags

[Updated on: Wed, 10 February 2021 07:43]

Report message to a moderator

Previous Topic:	Load XML data through sqlldr
Next Topic:	Optimization of sqlldr performance

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 30 10:34:40 CDT 2025