Re: Determine all updates to DB between 2 points in time?

From: Mark Bole <makbo_at_pacbell.net>
Date: Thu, 09 Dec 2004 16:19:59 GMT
Message-ID: <PW_td.31180$zx1.13728@newssvr13.news.prodigy.com>

Howard J. Rogers wrote:
> Stuart Smith wrote:
>

>> Is it possible to examine/process the Oracle log files to see what
>> updates have occurred to any data between to points in time? 

>
>
> Check out Log Miner.
>

[...]
> HJR
>
>

>> I would
>> like to use such a facility for testing purposes to ensure that only
>> the updates I expected are actually taking place.
>>

When checking "only the updates expected", be aware that the mined logs contain transactions that were rolled back as well as those that were committed.

Mark Bole Received on Thu Dec 09 2004 - 10:19:59 CST