开发者

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.

  1. 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.

    1. 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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜