You can specify command-line parameters in the SQL*Loader control file using the OPTIONS clause. This can be useful if you often use a control file with the same set of options. The OPTIONS clause precedes the LOAD DATA statement.
The following command-line parameters can be specified using the OPTIONS clause. These parameters are described in greater detail in SQL*Loader Command-Line Reference.
BINDSIZE = n COLUMNARRAYROWS = n DATE_CACHE = n DEGREE_OF_PARALLELISM= {degree-num|DEFAULT|AUTO|NONE} DIRECT = {TRUE | FALSE} ERRORS = n EXTERNAL_TABLE = {NOT_USED | GENERATE_ONLY | EXECUTE} FILE = tablespace file LOAD = n MULTITHREADING = {TRUE | FALSE} PARALLEL = {TRUE | FALSE} READSIZE = n RESUMABLE = {TRUE | FALSE} RESUMABLE_NAME = 'text string' RESUMABLE_TIMEOUT = n ROWS = n SILENT = {HEADER | FEEDBACK | ERRORS | DISCARDS | PARTITIONS | ALL} SKIP = n SKIP_INDEX_MAINTENANCE = {TRUE | FALSE} SKIP_UNUSABLE_INDEXES = {TRUE | FALSE} STREAMSIZE = n TRIM= {LRTRIM|NOTRIM|LTRIM|RTRIM|LDRTRIM}
The following is an example use of the OPTIONS clause that you could use in a SQL*Loader control file:
OPTIONS (BINDSIZE=100000, SILENT=(ERRORS, FEEDBACK) )