rem -----------------------------------------------------------------------
rem Filename:   logmgr.sql
rem Purpose:    Log Miner: extract undo statements from online and archived
rem             redo log files based on selection criteria.
rem Date:       21-Sep-2000
rem Author:     

rem -----------------------------------------------------------------------

-- Create a dictionary file 
--   (init.ora parameter utl_file_dir must be set)
exec dbms_logmnr_d.build('mydictfile', '/tmp');

-- Register log files, can be from a different db
--   (NEWFILE=start new list/ ADDFILE=add next file)
exec dbms_logmnr.add_logfile(
	LogFileName =>
'/app/oracle/arch/oradba/log_1_0000000027.oradba', 
	Options     => dbms_logmnr.NEW);
exec dbms_logmnr.add_logfile(
	LogFileName =>
'/app/oracle/arch/oradba/log_1_0000000028.oradba', 
	Options     => dbms_logmnr.ADDFILE);

-- Start the logminer session
exec dbms_logmnr.start_logmnr(DictFileName => '/tmp/mydictfile');

-- Query v_$logmnr_contents view to extract required info
select timestamp, sql_undo
from   sys.v_$logmnr_contents
where  seg_name = 'EMPLOYEES';

-- Stop the logminer session
exec dbms_logmnr.end_logmnr;