3,491
社区成员
发帖
与我相关
我的任务
分享
create table test as select * from user_objects where 1=0;
insert into test select * from user_objects;
delete from test where rownum<=2;
update test set object_name=lower(object_name);
commit;
-- 建立字典文件
exec dbms_logmnr_d.build(dictionary_filename => 'logmnr.dic',dictionary_location => '/home/oracle/oradir',options => dbms_logmnr_d.store_in_flat_file);
-- 建立日志分析表
exec dbms_logmnr.add_logfile(LogFileName => '/home/oracle/oradata/ORCL/redo01.log',Options => dbms_logmnr.new);
-- 添加用于分析的日志文件
exec dbms_logmnr.add_logfile(LogFileName => '/home/oracle/oradata/ORCL/redo02.log',Options => dbms_logmnr.addfile);
exec dbms_logmnr.add_logfile(LogFileName => '/home/oracle/oradata/ORCL/redo03.log',Options => dbms_logmnr.addfile);
-- 启动logminer进行分析
exec dbms_logmnr.start_logmnr(dictfilename => '/home/oracle/oradir/logmnr.dic');