Home » RDBMS Server » Server Utilities » SQL Loader (12c)
SQL Loader [message #683583] Thu, 04 February 2021 01:29 Go to next message
deepakdot
Messages: 89
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
Re: SQL Loader [message #683585 is a reply to message #683583] Thu, 04 February 2021 02:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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.

Re: SQL Loader [message #683651 is a reply to message #683585] Wed, 10 February 2021 07:22 Go to previous messageGo to next message
deepakdot
Messages: 89
Registered: July 2015
Member
Mike,

ERRORS=0 does not help. still it loads the good data. I am using very large bind size also.
Re: SQL Loader [message #683652 is a reply to message #683651] Wed, 10 February 2021 07:42 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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:
  


Current Time: Thu Mar 28 05:33:24 CDT 2024