ТЕМА:

var current_log char(255)



execute select max(member) into :current_log from v$log l, v$logfile f where l.group#=f.group# and l.status='CURRENT'



execute sys.dbms_logmnr.add_logfile(:current_log, sys.dbms_logmnr.new)



execute sys.dbms_logmnr.start_logmnr(options=>sys.dbms_logmnr.dict_from_online_catalog);



drop table logmnr_test01;



create table logmnr_test01(id number primary key, value number);



begin

  for j in 1..10 loop

    insert into logmnr_test01 values(j,j);

  end loop;

  commit;

end;

/





select *

from v$logmnr_contents

where seg_owner=USER

and seg_name = 'LOGMNR_TEST01'

/

begin

  for j in 1..10 loop

    insert into logmnr_test01 values(j,j);

  end loop;

  commit;

end;

/