What Is a SQL*Loader Control File

Q

What Is a SQL*Loader Control File? - Oracle DBA FAQ - Loading and Exporting Data

✍: FYIcenter.com

A

A SQL*Loader control file a text that defines how data files should be loaded into the database. It allows you to specify:

  • Where is the input data file.
  • The format of the input date file.
  • The target table where the data should be loaded.
  • How input data fields should be mapped to target table columns.
  • Select criteria to select input records for loading.
  • Where to output errors.

2007-04-30, 4662👍, 0💬