La page à Guillaume - Export Oracle

echo off
cls

set LOGFILE=EXP_%3_%1.log
set DMPFILE=%3_%1.dmp

IF NOT %1zaza == zaza GOTO :deb1
echo *** ERREUR - Parametre 1 (user) non renseigne
goto :FIN

:deb1
IF NOT %2zaza == zaza GOTO :deb2
echo *** ERREUR - Parametre 2 (password) non renseigne
goto :FIN

:deb2
IF NOT %3zaza == zaza GOTO :DEBUT
echo *** ERREUR - Parametre 3 (alias) non renseigne
goto :FIN

:DEBUT

rem set NLS_CHARACTERSET=AMERICAN_AMERICA.WE8ISO8859P1
rem set NLS_LANG=AMERICAN_AMERICA.UTF8

set STATS=n

IF %4x == yx set STATS=y
IF %4x == Yx set STATS=y
IF %4x == ox set STATS=y
IF %4x == Ox set STATS=y

echo --------------------------------------------------------------------
echo *** EXPORT.BAT user pwd alias stats
echo     - Parametres :
echo        - user : %1
echo        - pwd   : %2
echo        - alias : %3
echo        - stats : %STATS%
echo     - Output :
echo        - LOGFILE : %LOGFILE%
echo        - DMPFILE : %DMPFILE%
echo --------------------------------------------------------------------
echo

IF %STATS% == n GOTO :SANSSTAT

:AVECSTAT
exp %1/%2@%3 OWNER=%1 LOG=%LOGFILE% GRANTS=Y ROWS=Y COMPRESS=N FILE=%DMPFILE%
goto :FIN

:SANSSTAT
exp %1/%2@%3 OWNER=%1 LOG=%LOGFILE% GRANTS=Y ROWS=Y COMPRESS=N FILE=%DMPFILE% statistics=none

:FIN

echo
echo --------------------------------------------------------------------
echo - EXPORT.BAT FIN
echo --------------------------------------------------------------------

echo on