Return code/ exit code for Oracle's DataPump API
I w开发者_运维知识库rapped oracle's IMPDP and EXPDP in a console and could not find a good place for the return codes that these two return. I want to be more specific in pointing out errors than just a 0/1 Pass/Fail.
It looks like oracles DataPump is returning only three exit codes.
EX_SUCC 0 : The export or import job completed successfully. No errors are displayed to the output device or recorded in the log file, if there is one.
2.EX_SUCC_ERR 5 : The export or import job completed successfully but there were errors encountered during the job. The errors are displayed to the output device and recorded in the log file, if there is one.
- EX_FAIL 1 :The export or import job encountered one or more fatal errors.
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL3834
If you specify a unique job name for the import and export, you can check the STATUS
and ADDITIONAL_INFO
(among other useful columns) under the all_scheduler_job_run_details
view for success/failure status and any errors encountered.
精彩评论