Results 1 to 2 of 2

Thread: Oracle Log Miner Problems

  1. #1
    Join Date
    Dec 2006
    Posts
    1

    Oracle Log Miner Problems

    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

  2. #2
    Join Date
    Oct 2005
    Posts
    2,557
    Try looking up what the error message is. Takes all of 5 seconds to find in Oracle documentation. tahiti.oracle.com > pick a version > books > ERR

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •