The SQLLoader control file is a text file that contains data definition language (DDL) instructions for a SQLLoader job. Successfully using a SQL*Loader control file requires an understanding of the ...

For sql loader, the script file has two sections: control file and data file. The control file specifies the table name, column names, data types, field delimiters, and other options.

View Listing B.The column "sysid" is a dummy column that contains the object's OID. The SQL*Loader control file syntax "oid(sysid)" takes this column and applies it to the object as it's created.

Sql loader can also restart from the point of failure, if the control file is configured properly. Sql loader also creates bad files and discard files to store the records that are rejected or ...