Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Loads data from external files into tables of an Oracle database. It has a powerful data parsing engine that puts little limitation on the format of the data in the datafile.

Object Type Identification

...

NameDescription

.dat

.ctl

.ldr

SQL*Loader is the utility to use for high performance data loads. The data can be loaded from any text file and inserted into the database.

Object Type Code

SQL_LDR

Attributes

NameDescriptionDefault ValueSupported Values
SourceObject Source Location Type

SCM

SCM
Target LocationPath to where the file should be deployed.$<PROD_TOP>/bin/
Log FileConfiguration file used to download/upload data.loader.log

...