What Is a SQL*Loader Control File in Oracle

Q

What Is a SQL*Loader Control File in Oracle?

✍: 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.

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-11-27, 254👍, 0💬