February 6th, 2004, 08:39 AM
SQL Loader commit issue
I have a requirement to load data with SQL Loader.
The files may have data bout 1000 rows in it.
The problem is I should not commit any of the rows loaded to the database until all rows in the file are processed.
The commit should be done only if there are no errors.
Is this possible with SQL loader ?? If yes how to do it.
February 6th, 2004, 09:34 AM
I would use SQL*Loader to load the data to a staging table and then apply the logic on this table and move the rows as needed.