Download
slide1 n.
Skip this Video
Loading SlideShow in 5 Seconds..
REM ========================================================================== PowerPoint Presentation
Download Presentation
REM ==========================================================================

REM ==========================================================================

156 Vues Download Presentation
Télécharger la présentation

REM ==========================================================================

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. REM ==========================================================================

  2. REM Script# 1

  3. REM Realiza backup del esquema HR con Windows Scheduler / at command

  4. REM ==========================================================================

  5. set ORACLE_BASE=D:\oracle\product\10.2.0\db_xxx

  6. set backupdir=d:\BACKUPS\

  7. set backname=db_xxx_HR.DMP

  8. set datetimef=%date:~-4%_%date:~3,2%_%date:~0,2%__%time:~0,2%_%time:~3,2%_%time:~6,2%

  9. expdp usuario/pwd schemas=hr directory=BACKUPS dumpfile=db_xxx_hr.dmp logfile=db_xxx_hr.log

  10. ren %backupdir%db_xxx_hr.dmp HR_%datetimef%.dmp

  11. ren %backupdir%db_xxx_hr.log HR_%datetimef%.log

  12. REM ==========================================================================

  13. REM Script# 1

  14. REM Fin

  15. REM ==========================================================================