Logminer run as procedure
I like to run logminer as scheduler, I done oracle scheduler before , but I am not sure how to run logminer as procedure,
my plane is make logminer procedure and run procedure scheduler job.
Here is my command for logminer, can you help to build procedure about this?
It has error PLS-00201: identifier 'DBMS_LOGMNR' must be declared.
can you help to build this procedure?
CREATE OR REPLACE PROCEDURE ORAASFS.LOGMINER IS
BEGIN
EXECUTE IMMEDIATE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/home/oracle/oradata/SFS/arch/1_32323_734026431.dbf', OPTIONS => DBMS_LOGMNR.NEW);
EXECUTE IMMEDIATE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
EXECUTE IMMEDIATE DBMS_LOGMNR.END_LOGMNR;
END LOGMINER;