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.


sqlldr [paramval [paramval...]

paramval ::= parameter=value

parameter ::= {
|date_cache=number_of_entries_in_the_date_cache ...

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

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.