C:\Users\hanh>sqlldr help=y userid ORACLE username/password control Control file name log Log file name bad Bad file name data Data file name discard Discard file name discardmax Number of discards to allow skip Number of logical records to skip load Number of logical records to load errors Number of errors to allow rows Number of rows in conventional path bind array or between direct path data saves bindsize Size of conventional path bind array in bytes silent Suppress messages during run (header,feedback,errors,discards,pa rtitions) direct use direct path _synchro internal testing parfile parameter file: name of file that contains parameter specificati ons parallel do parallel load file File to allocate extents from skip_unusable_indexes disallow/allow unusable indexes or index partiti ons skip_index_maintenance do not maintain indexes, affected indexes a s unusable commit_discontinued commit loaded rows when load is discontinued _display_exitcode Display exit code for SQL*Loader execution readsize Size of Read buffer external_table use external table for load; NOT_USED, GENERATE_ONLY, EX ECUTE columnarrayrows Number of rows for direct path column array streamsize Size of direct path stream buffer in bytes multithreading use multithreading in direct path resumable enable or disable resumable for current session resumable_name text string to help identify resumable statement resumable_timeout wait time (in seconds) for RESUMABLE date_cache size (in entries) of date conversion cache
userid ORACLE username/password
control Control file name
log Log file name
bad Bad file name
data Data file name
discard Discard file name
discardmax Number of discards to allow
skip Number of logical records to skip
load Number of logical records to load
errors Number of errors to allow
rows Number of rows in conventional path bind array or between direct
path data saves
bindsize Size of conventional path bind array in bytes
silent Suppress messages during run (header,feedback,errors,discards,pa
rtitions)
direct use direct path
_synchro internal testing
parfile parameter file: name of file that contains parameter specificati
ons
parallel do parallel load
file File to allocate extents from
skip_unusable_indexes disallow/allow unusable indexes or index partiti
ons
skip_index_maintenance do not maintain indexes, affected indexes a
s unusable
commit_discontinued commit loaded rows when load is discontinued
_display_exitcode Display exit code for SQL*Loader execution
readsize Size of Read buffer
external_table use external table for load; NOT_USED, GENERATE_ONLY, EX
ECUTE
columnarrayrows Number of rows for direct path column array
streamsize Size of direct path stream buffer in bytes
multithreading use multithreading in direct path
resumable enable or disable resumable for current session
resumable_name text string to help identify resumable statement
resumable_timeout wait time (in seconds) for RESUMABLE
date_cache size (in entries) of date conversion cache