Here are the exit codes return by the sqlldr for unix and windows nt respectively.
Result Exit Code
All rows loaded successfully
EX_SUCC
All or some rows rejected
EX_WARN
All or some rows discarded
EX_WARN
Discontinued load
EX_WARN
Command-line or syntax errors
EX_FAIL
Oracle errors nonrecoverable for SQL*Loader
EX_FAIL
Operating system errors (such as file open/close and malloc)
EX_FTL
For UNIX, the exit codes are as follows:
EX_SUCC 0
EX_FAIL 1
EX_WARN 2
EX_FTL 3
For Windows NT, the exit codes are as follows:
EX_SUCC 0
EX_WARN 2
EX_FAIL 3
EX_FTL 4
If SQL*Loader returns any exit code other than zero, you should consult your system log files and SQL*Loader log files for
more detailed diagnostic information.
SQLLDR 返回值
最新推荐文章于 2020-10-10 17:52:49 发布