Ceci est une ancienne révision du document !

• Script permettant de faire un Export Oracle sur windows

REM ########################################################################################
REM # Script name: TOTSA-FullExpDPBck.bat
REM # Usage : execute directly, no option needed
REM ######
REM # Change control
REM # 1.00 	14/12/2025	script creation
REM # 1.00 	17/12/2025	added content=metadata_only

REM ########################################################################################
REM # Database to Backup
set ORACLE_SID=PCERP

REM # preparation of log name variable
set date_time=%date:~4,2%-%date:~7,2%-%date:~10,4%_%time:~0,2%-%time:~3,2%-%time:~6,2%
set log_date_time=%date_time: =0%

 
REM # DATAPUMP Metadata
set logfile_name=PCERP-metadata_%log_date_time%.log
H:\app\oracle\19c\db\bin\expdp.exe \"/ as sysdba\" directory=PCSBACKUPDIR dumpfile=PCERP-metadata.dmp logfile=%logfile_name% full=y reuse_dumpfiles=y content=metadata_only  LOGTIME=all parallel=12

REM # DATAPUMP FULL
set logfile_name=PCERP-full_%log_date_time%.log
H:\app\oracle\19c\db\bin\expdp.exe \"/ as sysdba\" directory=PCSBACKUPDIR dumpfile=PCERP-full.dmp logfile=%logfile_name% full=y reuse_dumpfiles=y EXCLUDE=STATISTICS FLASHBACK_TIME=SYSTIMESTAMP LOGTIME=all parallel=12