Skip_unusable_indexes - disallow/allow unusable indexes or index partitions Parallel - do parallel load (Default FALSE) Parfile - parameter file: name of file that contains parameter specifications Silent - suppress messages during run (header,feedback,errors,discards,ĭirect - use direct path (Default FALSE) (Default: Conventional path 64, Direct path all)īindsize - size of conventional path bind array in bytes (Default 256000) Rows - number of rows in conventional path bind array or between direct Load - number of logical records to load (Default all)Įrrors - number of errors to allow (Default 50) Skip - number of logical records to skip (Default 0)
Usage: SQLLDR keyword=value ĭiscardmax - number of discards to allow (Default all) It lists the available parameters and their default values. If you invoke SQL*Loader without specifying any parameters, SQL*Loader displays a help screen similar to the following. USERID=scott/tiger, ERRORS=999, LOAD=2000, DISCARD=toss.dsc, SQLLDR CONTROL=sample.ctl, LOG=sample.log, BAD=baz.bad, DATA=etc.dat You specify values for parameters, or in some cases, you can accept the default without entering a value. Parameters can be entered in any order, optionally separated by commas.
When you invoke SQL*Loader, you can specify certain parameters to establish session characteristics.
0 kommentar(er)
