َcreate dmp file oracle database 11g by time and data with batch file عمل دامب باليوم والساعه

Channel:

Ask gado

Subscribers:

1,780

Published on September 28, 2021 1:53:56 PM ● Video Link: https://www.youtube.com/watch?v=ACYHF-8hS3Q

Duration: 1:43

689 views

70

CREATE file bat from notepad and add




set day=%date:~0,3%
set month=%date:~4,2%
set daydate=%date:~7,2%
set year=%date:~-4%
set hour=%time:~0,2%
set minute=%time:~3,2%
set second=%time:~6,2%
set backup_date_time=%day%_%daydate%_%month%_%year%_%hour%_%minute%_%second%
expdp qema/qema@orcl schemas=qema,qema2 directory=dmpdir dumpfile=%backup_date_time% logfile=%backup_date_time%



-----
In database

CREATE DIRECTORY dmpdir AS 'D:\backup_data';
GRANT read, write ON DIRECTORY dmpdir TO qema;