Invoking SQL*Loader
Invoking SQL*Loader
On Unix systems, the command used to invoke SQL*Loader is sqlldr. On Windows systems running Oracle8i, release 8.1 or higher, the command is also sqlldr.
The command to execute SQL*Loader is as follows:
sqlldr USERID = <username>/<password> CONTROL = <control file name> LOG = <log file name>….
Issuing the sqlldr command by itself results in a list of valid command-line parameters being displayed. Command-line parameters are usually keyword/value pairs, and may be any combination of the following:
USERID = {username[/password] [@net_service_name]|/} Specifies the username and password to use when connecting to the database.
CONTROL = control_ file_name Specifies the name, which may include the path, of the control file. The default extension is .ctl.
LOG = path_ file_name Specifies the name of the log file to generate for a load session. You may include a path as well. By default, the log file takes on the name of the control file, but with a .log extension, and is written to the same directory as the control file.
BAD = path_ file_name Specifies the name of the bad file. You may include a path as part of the name. By default, the bad file takes the name of the control file, but with a .bad extension, and is written to the same directory as the control file.
DATA = path_ file_name Specifies the name of the file containing the data to load. You may include a path as part of the name. By default, the name of the control file is used, but with the .dat extension.
DISCARD = path_ file_name Specifies the name of the discard file. You may include a path as part of the name. By default, the discard file takes the name of the control file, but it has a .dis extension.
Other Parameters are:
DISCARDMAX=logical_record_countSKIP=logical_record_countSKIP_INDEX_MAINTENANCE={TRUE | FALSE}SKIP_UNUSABLE_INDEXES={TRUE | FALSE}LOAD=logical_record_countERRORS=insert_error_countROWS=rows_in_bind_arrayBINDSIZE=bytes_in_bind_arraySILENT=[(]keyword[,keyword...][)]DIRECT={TRUE | FALSE}PARFILE=path_file_namePARALLEL={TRUE | FALSE}READSIZE=bytes_in_read_bufferFILE=database_datafile_name
Leave a Reply
Want to join the discussion?Feel free to contribute!