Home » RDBMS Server » Server Administration » LOGMINER PROBLEM
LOGMINER PROBLEM [message #211980] Wed, 03 January 2007 06:08 Go to next message
sarankaran_y@yahoo.co.in
Messages: 5
Registered: November 2006
Location: CHENNAI
Junior Member
hi

I am doing audit in our db.i caught all the events by the user in sys.aud$.Now the problem is i want to see the changed values in the particular update transaction.I tried with XID but its not give the proper answer at all time.I am trying v$LOGMNR_contents

BEGIN 
    DBMS_LOGMNR.ADD_LOGFILE('D:\ORACLEDB\MRTEDEV\MRTEDEV\REDO01.LOG');
    DBMS_LOGMNR.ADD_LOGFILE('D:\ORACLEDB\MRTEDEV\MRTEDEV\REDO02.LOG');
    DBMS_LOGMNR.ADD_LOGFILE('D:\ORACLEDB\MRTEDEV\MRTEDEV\REDO03.LOG');
    END;


BEGIN
    DBMS_LOGMNR.START_LOGMNR
    (OPTIONS=>DBMS_LOGMNR.DICT_FROM_ONLINE_CATALOG);
END;


I queried the v$logmnr_contents by using table_name. It shows records.

But, the sql_undo value of the column name shows streamstatus=null like this.

When I connect to sql next time,The query did not show any records. Why this mismatch? How can I find?



Re: LOGMINER PROBLEM [message #212264 is a reply to message #211980] Thu, 04 January 2007 07:48 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Quote:
But, the sql_undo value of the column name shows streamstatus=null like this.


Please remember to post the output.
Previous Topic: OS 1326
Next Topic: Role
Goto Forum:
  


Current Time: Sun Dec 11 00:20:58 CST 2016

Total time taken to generate the page: 0.07319 seconds