Have Geek Brain

Return / Exit Code for Oracle DataPump API

I wrapped the IMPDP and EXPDP oracle in the console and couldn't find a good place for the return codes these two are returning. I want to be more specific in indicating errors than just 0/1 Pass / Fail.

+2


a source to share


2 answers


If you provide a unique job name for the import and export, you can check STATUS

and ADDITIONAL_INFO

(among other useful columns) in the view all_scheduler_job_run_details

for success / failure status and any errors encountered.



0


a source


It looks like DataPump oracles only return three exit codes.

  • EX_SUCC 0: Export or import job completed successfully. Errors are not displayed on the output device or are not written to the log file, if any.

    2.EX_SUCC_ERR 5: The export or import job completed successfully, but errors were encountered while running. Errors are displayed on the output device and written to the log file, if available.

    1. EX_FAIL 1: One or more fatal errors occurred as a result of export or import.


http://docs.oracle.com/cd/E11882_01/server.112/e22490/dp_overview.htm#SUTIL3834

0


a source






More articles:


All Articles