Name

sqlldr

Use sqlldr, which is the executable for the SQL*Loader utility, to load data from a text file into a table. This text file is usually referred to as a flat file. You create a control file in which you define the mapping of various columns of the target database table to the fields in the text file. The job of sqlldr is to use the mapping defined in the control file to load data from the text file into the table. In one sqlldr session, you can load data from more than one file and to more than one table.

Syntax

sqlldr [paramval [paramval...]

paramval ::= parameter=value

parameter ::= {
 userid=username[/password][@net_service_name]
|control=control_file_name
|log=log_file_name
|bad=bad_file_name
|data=data_file_name
|discard=discard_file_name
|discardmax=logical_record_count
|skip=logical_record_count
|skip_unusable_indexes=true|false
|load=logical_record_count
|errors=insert_error_count
|rows=rows_in_bind_array
|bindsize=bytes_in_bind_array
|silent={header|feedback|errors|discards
        |partitions|all}
|direct={true|false}
|parfile=parameter_file_name
|parallel={true|false}
|file=database_datafile_name
|skip_index_maintenance={true|false}
|commit_discontinued={true|false}
|readsize=bytes_in_read_buffer
|external_table={not_used|generate_only|execute}
|columnarrayrows=rows_in_column_array
|streamsize=bytes_in_stream_buffer
|multithreading={true|false}
|resumable={true|false}
|resumable_name=res_stmt_identifier
|resumable_timeout=wait_time_in_seconds
|date_cache=number_of_entries_in_the_date_cache ...

Get Oracle Utilities Pocket Reference now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.