如何创建和使用LogMnr?
exec dbms_logmnr.add_logfile('C:\oracle\oradata\orcl\archive\ORCLARCHIVE_T001S03894.ARC',dbms_logmnr.new);
exec dbms_logmnr.add_logfile('C:\oracle\oradata\orcl\archive\ORCLARCHIVE_T001S03895.ARC',dbms_logmnr.addfile);
exec dbms_logmnr.add_logfile('C:\oracle\oradata\orcl\archive\ORCLARCHIVE_T001S03896.ARC',dbms_logmnr.addfile);
exec dbms_logmnr.add_logfile('C:\oracle\oradata\orcl\archive\ORCLARCHIVE_T001S03897.ARC',dbms_logmnr.addfile);
exec dbms_logmnr.start_logmnr (startscn => 4954670,endscn => 4959095,startime=>to_date('2003-08-22 09:00:00','yyyy-mm-dd hh24:mi:ss'),endtime=>to_date('2003-08-22 12:00:00','yyyy-mm-dd hh24:mi:ss'),dictfilename =>'C:\oracle\admin\orcl\exp\logmnr_1.txt');
ERROR 位于第 1 行:
ORA-06550: 第 1 行, 第 7 列:
PLS-00306: 调用 'START_LOGMNR' 时参数数量或类型错误
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored