Database Utilities
ContentsOpens a new window
Opens a new window
Page 330 of 1018

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 StudiesOpens a new window" for information on how to access case studies.)

Previous PageOpens a new window
Page 330 of 1018
Next PageOpens a new window