select * from dba_directories;
exec utl_file.fremove('MYDIRECTORY', 'test.txt');
EXEC UTL_FILE.FREMOVE ('EXPORT_AUTO','exp1213'||'_'||TO_CHAR(SYSDATE-2,'DDMMYYYY')||'.DMP');
------------------------
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'REMOVEexp',
job_type => 'PLSQL_BLOCK',
job_action => 'BEGIN UTL_FILE.FREMOVE (''EXPORT_AUTO'',''exp1213''||''_''||TO_CHAR(SYSDATE-2,''DDMMYYYY'')||''.DMP''); END;',
start_date => '01-APR-12 01.00.00 PM ASIA/CALCUTTA',
repeat_interval => 'freq=DAILY',
end_date => NULL,
enabled => TRUE,
comments => 'JOB to remove old dump file');
END;
/
exec dbms_scheduler.run_job('removeexp');
No comments:
Post a Comment