Executing SQL *Loader

Syntax

sqlldr keyword=value [keyword=value …]

Example

sqlldr userid=system/manager control=profile.ctl log=profile.log

Parameters

USERID={username[/password][@net_service_name]|/}
CONTROL=control_file_name
LOG=path_file_name
BAD=path_file_name
DATA=path_file_name
DISCARD=path_file_name
DISCARDMAX=logical_record_count
SKIP=logical_record_count
SKIP_INDEX_MAINTENANCE={TRUE | FALSE}
SKIP_UNUSABLE_INDEXES={TRUE | FALSE}
LOAD=logical_record_count
ERRORS=insert_error_count
ROWS=rows_in_bind_array
BINDSIZE=bytes_in_bind_array
SILENT=[(]keyword[,keyword…][)]
DIRECT={TRUE | FALSE}
PARFILE=path_file_name
PARALLEL={TRUE | FALSE}
READSIZE=bytes_in_read_buffer
FILE=database_datafile_name

Read more

SQL*Loader Overview

Overview

SQL*Loader is the primary method to load data to Oracle database from external files. It has a powerful data parsing engine which puts little limitation on the format of the data in the datafile.

Key Features

• Load data across a network. This means that a SQL*Loader client can be run on a different system from the one that is running the SQL*Loader server.
• Load data from multiple datafiles during the same load session
• Load data into multiple tables during the same load session
• Specify the character set of the data
• Selectively load data
• Load data from disk, tape, or named pipe
• Specify the character set of the data
• Generate sophisticated error reports, which greatly aid troubleshooting
• Load arbitrarily complex object-relational data
• Use either conventional or direct path loading.

Read more