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 ==========================================================================