Thursday, 12 June 2025

Configure Export Datapump backup using DBMS_SCHEDULER



BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'Export_Database_Full',
job_type => 'executable',
job_action => 'expdp system/sys directory=expbkp dumpfile=exp.dmp logfile=exp.log full=y'
start_date => TO_TIMESTAMP_TZ('2025/06/04 09:13:34.297000 +03:00','yyyy/mm/dd hh24:mi:ss.ff tzh:tzm'),
repeat_interval => 'FREQ=DAILY;',
end_date => NULL,
enabled => FALSE,
comments => 'Daily');
END;
/

No comments:

Post a Comment