Loading Data into Empty Tables

If the tables you are loading into are empty, then use the INSERT option.

INSERT

This is SQL*Loader's default method. It requires the table to be empty before loading. SQL*Loader terminates with an error if the table contains rows. Case study 1, Loading Variable-Length Data, provides an example. (See "SQL*Loader Case Studies" for information on how to access case studies.)