Oracle 的 DataPump API 的返回码/退出码
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/2802892/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Return code/ exit code for Oracle's DataPump API
提问by Shravan
I wrapped 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.
我将 oracle 的 IMPDP 和 EXPDP 包装在控制台中，但找不到这两个返回的返回代码的好地方。我想更具体地指出错误，而不仅仅是 0/1 通过/失败。
回答by Captain Hyman Sparrow
It looks like oracles DataPump is returning only three exit codes.
看起来 oracles DataPump 只返回三个退出代码。
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.
EX_SUCC 0 ：导出或导入作业成功完成。如果有错误，则不会向输出设备显示错误或记录在日志文件中。
2.EX_SUCC_ERR 5：导出或导入作业成功完成，但在作业过程中遇到错误。错误将显示到输出设备并记录在日志文件中（如果有）。
- EX_FAIL 1 ：导出或导入作业遇到一个或多个致命错误。
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL3834
http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL3834
回答by Adam Hawkes
If you specify a unique job name for the import and export, you can check the STATUSand ADDITIONAL_INFO(among other useful columns) under the all_scheduler_job_run_detailsview for success/failure status and any errors encountered.
如果您为导入和导出指定唯一的作业名称，您可以检查视图下的STATUS和ADDITIONAL_INFO（以及其他有用的列）以all_scheduler_job_run_details了解成功/失败状态以及遇到的任何错误。
