Hi all,
I need help on executing archived log files in the database, instead of inserting each of the logs in the execute statement below one by one is there a way i can include all the logs at once in one single statement in a script?
EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/u02/arch/1_50662_581101112.arc' ,OPTIONS => DBMS_LOGMNR.NEW); EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => '/u02/arch/1_50706_581101112.arc'
I need to mine over a thousand logs for a report and including them one by one is not feasible.
Kindly help out.
Regards.