Log Miner

Connected as SYS

SQL> insert into scott.emp values(7979,'ADAM','MANAGER',7782,to_date('03.12.1981','dd.mm.yyyy'),5000,1200,10);

1 row inserted

SQL> insert into scott.emp values(7978,'KELLY','MANAGER',7784,to_date('03.12.1982','dd.mm.yyyy'),5000,1200,10);

1 row inserted

SQL> commit;

Commit complete

SQL> select * from v$logfile;

GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------------------------------------------------------- ---------------------
3 ONLINE C:\ORACLE\PRODUCT\ORADATA\SHARP\REDO03.LOG NO
2 ONLINE C:\ORACLE\PRODUCT\ORADATA\SHARP\REDO02.LOG NO
1 ONLINE C:\ORACLE\PRODUCT\ORADATA\SHARP\REDO01.LOG NO

SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => 'C:\ORACLE\PRODUCT\ORADATA\SHARP\REDO03.LOG', OPTIONS => DBMS_LOGMNR.NEW);

PL/SQL procedure successfully completed

SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => 'C:\ORACLE\PRODUCT\ORADATA\SHARP\REDO02.LOG', OPTIONS => DBMS_LOGMNR.NEW);

PL/SQL procedure successfully completed

SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LOGFILENAME => 'C:\ORACLE\PRODUCT\ORADATA\SHARP\REDO01.LOG', OPTIONS => DBMS_LOGMNR.NEW);

PL/SQL procedure successfully completed

SQL> EXECUTE DBMS_LOGMNR.START_LOGMNR(OPTIONS => DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);

PL/SQL procedure successfully completed

select * from v$logmnr_contents where username='SCOTT' and table_name='EMP';

EXECUTE DBMS_LOGMNR.END_LOGMNR();