6.1. Deleting and Starting Over

Restarting a load from the beginning is often the easiest approach. You should consider it in cases where no data was actually saved to the database, or in cases where you can reliably delete any data that was saved prior to the failure. Note that I said "consider." If you are loading a large amount of data, you may not want to spend the time loading the same data twice. Instead, you'll want to continue processing from the point at which the failure occurred.

6.1.1. When You're Loading an Empty Table

Regardless of the load type, if you were loading into a table that was empty to begin with, and you are sure that no other processes have modified that table, then you can delete the partially loaded data from the table and run the load again. For this exact reason, it's not uncommon to load data from an external file into a work table using a LOAD statement such as one of the following: