SQL Loader [message #683583] |
Thu, 04 February 2021 01:29 |
|
deepakdot
Messages: 91 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
|
|
|
|
|
|