Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Logminer run as procedure

s197oo302May 6 2011 — edited Jun 7 2011
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;

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jul 5 2011
Added on May 6 2011
7 comments
1,284 views