Thursday, 28 April 2011

Export Exit Codes

INTRODUCTION
============
This is a short reference note describing the EXIT codes (errorlevel)
used by the Export and Import utilities.

EXIT CODES
==========
A. Successful export/import.
   -------------------------
   Result    : Export terminated successfully without warnings
               Import terminated successfully without warnings
   Exit Code : EX_SUCC
   Exit Level: 0
B. Successful export/import with warnings.
   ---------------------------------------
   Result    : Export terminated successfully with warnings
               Import terminated successfully with warnings
   Exit Code : EX_OKWARN
   Exit Level: 0 (for Unix platforms)
               1 (for Windows platform with Oracle9i, Oracle8i, and below)
               3 (for Windows platform with Oracle10g and higher)
C. Unsuccessful export/import.
   ---------------------------
   Result    : Export terminated unsuccessfully
               Import terminated unsuccessfully
   Exit Code : EX_FAIL
   Exit Level: 1 (for Unix platforms, and for Windows platforms with
                  Oracle10g and higher)
               3 (for Windows platform with Oracle9i, Oracle8i, and below)

CHECK
=====
To determine the errorlevel at the commandline after a command ends:
- Unix Bourne/Korn shell:
 echo $?
- Unix C Shell:
 echo $status
- Windows:
 echo %ERRORLEVEL%

echo %ORACLE_SID%

No comments:

Post a Comment