Version Oracle Database 9i
This code have executed succeffully
Code:
connect sys/apia AS sysdba
spool log.log
@c:\ORACLE\rdbms\admin/dbmslm.sql
@c:\ORACLE\rdbms\admin/dbmslmd.sql
EXECUTE SYS.DBMS_LOGMNR_D.BUILD('dic.ora','c:\oracle\temp',SYS.DBMS_LOGMNR_D.STORE_IN_FLAT_FILE);
EXECUTE SYS.Dbms_Logmnr.Add_Logfile(options => SYS.Dbms_Logmnr.New, logfilename =>'C:\ORACLE\oradata\REDO01.LOG');
EXECUTE SYS.Dbms_Logmnr.Add_Logfile( options => SYS.Dbms_Logmnr.AddFile, logfilename => 'C:\ORACLE\oradata\REDO02.LOG');
EXECUTE SYS.Dbms_Logmnr.Add_Logfile( options => SYS.Dbms_Logmnr.AddFile, logfilename => 'C:\ORACLE\oradata\REDO03.LOG');
EXECUTE SYS.Dbms_Logmnr.Start_Logmnr(dictfilename =>'c:\oracle\temp\dic.ora');
ALTER SYSTEM SWITCH LOGFILE;
spool off;
I have some problems with Log Miner
this message displayed when the query
Code:
SELECT scn, operation, sql_redo,
sql_undo FROM v$logmnr_contents
Code:
ora-01306, can you please help me
thnaks