O'Reilly logo

Oracle Utilities Pocket Reference by Sanjay Mishra

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required