imp和exp这些oracle命令的命令行返回值都是什么
imp和exp这些oracle命令的命令行返回值都是什么，windows下的，查资料查不到，谁知道告诉下
[解决办法]
参见: http://www.dba-oracle.com/t_scripts_windows_export.htm
以及Oracle的matelink

c:> exp=%PARFILE%:

REM +--------------------------------------+
REM 
[解决办法]
 VALIDATE COMMAND-LINE PARAMETERS                                         
[解决办法]

REM +--------------------------------------+

if (%1)==() goto USAGE
if (%2)==() goto USAGE
if (%3)==() goto USAGE


REM +--------------------------------------+
REM 
[解决办法]
 VALIDATE ENVIRONMENT VARIABLES                                           
[解决办法]

REM +--------------------------------------+

REM set ORABACKUP=C:\oracle\orabackup\JEFFDB\export
REM set ORALOG=C:\oracle\custom\oracle\log
REM set ORATMP=C:\oracle\custom\oracle\temp

if (%ORALOG%)==() goto ENV_VARIABLES
if (%ORATMP%)==() goto ENV_VARIABLES
if (%ORABACKUP%)==() goto ENV_VARIABLES


REM +--------------------------------------+
REM 
[解决办法]
 DECLARE ALL GLOBAL VARIABLES.                                            
[解决办法]

REM +--------------------------------------+

set FILENAME=export_backup_online_full_9i
set DB_USERNAME=%1%
set DB_PASSWORD=%2%
set TNS_ALIAS=%3%
set PARFILE=%ORATMP%\%FILENAME%_%TNS_ALIAS%.parfile
set LOGFILE=%ORALOG%\%FILENAME%_%TNS_ALIAS%.log
set DUMPFILE=%ORABACKUP%\exp_full_%TNS_ALIAS%.dmp


REM +--------------------------------------+
REM 
[解决办法]
 REMOVE OLD LOG AND PARAMETER FILE(S).                                    
[解决办法]

REM +--------------------------------------+ 
 

del /q %PARFILE%
del /q %LOGFILE%


REM +--------------------------------------+
REM 
[解决办法]
 WRITE EXPORT PARAMETER FILE.                                             
[解决办法]

REM +--------------------------------------+

echo userid=%DB_USERNAME%/%DB_PASSWORD%@%TNS_ALIAS% > %PARFILE%
echo buffer=50000000 >> %PARFILE%
echo file=%DUMPFILE% >> %PARFILE%
echo compress=n >> %PARFILE%
echo grants=y >> %PARFILE%
echo indexes=y >> %PARFILE%
echo direct=no >> %PARFILE%
echo log=%LOGFILE% >> %PARFILE%
echo rows=y >> %PARFILE%
echo consistent=y >> %PARFILE%
echo full=y >> %PARFILE%
REM echo owner=(SCOTT) >> %PARFILE%
REM echo tables=(EMP, DEPT) >> %PARFILE%
echo triggers=y >> %PARFILE%
echo statistics=none >> %PARFILE%
echo constraints=y >> %PARFILE%


REM +--------------------------------------+
REM 
[解决办法]
 MOVE OLD EXPORT (DUMP) FILE.                                             
[解决办法]

REM +--------------------------------------+

del /q %DUMPFILE%.backup
move %DUMPFILE% %DUMPFILE%.backup


REM +--------------------------------------+
REM 
[解决办法]
 PERFORM EXPORT.                                                          
[解决办法]

REM +--------------------------------------+

exp parfile=%PARFILE%


REM +--------------------------------------+
REM 
[解决办法]
 SCAN THE EXPORT LOGFILE FOR ERRORS.                                      
[解决办法]

REM +--------------------------------------+ 
 

echo ...
echo Analyzing log file for EXP- errors...
findstr /I /C:"EXP-" %LOGFILE%
if errorlevel 0 if not errorlevel 1 echo EXP- Errors:  %FILENAME% %TNS_ALIAS% %COMPUTERNAME% %DATE% %TIME% %LOGFILE%

echo ...
echo Analyzing log file for ORA- errors...
findstr /I /C:"ORA-" %LOGFILE%
if errorlevel 0 if not errorlevel 1 echo ORA- Errors:  %FILENAME% %TNS_ALIAS% %COMPUTERNAME% %DATE% %TIME% %LOGFILE%

echo ...
echo Analyzing log file for warnings...
findstr /I /C:"Export terminated successfully with warnings" %LOGFILE%
if errorlevel 0 if not errorlevel 1 echo WARNING: %FILENAME% %TNS_ALIAS% %COMPUTERNAME% %DATE% %TIME% %LOGFILE%

echo ...
echo Analyzing log file for errors...
findstr /I /C:"Export terminated unsuccessfully" %LOGFILE%
if errorlevel 0 if not errorlevel 1 echo ERROR: %FILENAME% %TNS_ALIAS% %COMPUTERNAME% %DATE% %TIME% %LOGFILE%


echo ...
echo END OF FILE REPORT
echo Filename      : %FILENAME%
echo Database      : %TNS_ALIAS%
echo Hostname      : %COMPUTERNAME%
echo Date          : %DATE%
echo Time          : %TIME%
echo EXP Log File  : %LOGFILE%