Hi All,
I an using oracle 11g express edition .i want to export my oracle database using DBMS_SCHEDULER package after every 10 minutes. i am using ubuntu 14.04 os.
I have created one procedure and its successfully created but export of db is not working.
Procedure :
conn sys/oracle as sysdba
create or replace procedure Export_db
as
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'Expot_db',
job_type => 'executable',
job_action => 'exp kan/kan file=/home/ats/Desktop/backup.dmp',
start_date => SYSTIMESTAMP,
repeat_interval => 'FREQ=MINUTELY; INTERVAL=10;',
end_date => NULL,
enabled => TRUE,
comments => 'export_db_every_10 minutes');
END;
grant execute on Export_db to kan;
Please help me.