Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Maybe very silly question abou Log Miner

Maybe very silly question abou Log Miner

From: Dusan Bolek <pagesflames_at_usa.net>
Date: 28 Mar 2003 00:47:40 -0800
Message-ID: <1e8276d6.0303280047.45cb0dbf@posting.google.com>


I'm trying to use Log Miner as some kind of audit technology. Original idea was to take archived redologs and read them on other dedicated database. However, I cannot overcome one single problem, which I know from beginning of my logmining in 8.1.6. Problem is that keys used for identifiing row to be updated (in where conditions) are ommited and instead of this in sql_redo from v$logmnr_contents are used rowids. Example of original insert:

update log_test set text3 = 'some new value' where id = 777;

and INSERT from v$logmnr_contents:

update "BOLEK"."LOG_TEST" set "TEXT3" = 'some new value' where "TEXT3" = 'some old value' and ROWID = 'AAAFrVAABAAAHrKAAC';

I knew that this is the format of logminer output, but it still puzzles me if there is no other way to find a key used for original update. With this is logmining in any other database then the original one unusable from audit point of view. For auditing, I need to know exactly which row was updated.
Is there any way to accomplish this, or is this just a limitation that logminer has and there is nothing to do with?

Thanks for your answers

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.
Received on Fri Mar 28 2003 - 02:47:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US