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

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 09 Dec 2004 20:06:04 +1100
Message-ID: <41b8157d$0$26811$afc38c87@news.optusnet.com.au>

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.

If you've never used it before, and want a quick intro, try http://www.dizwell.com/html/pitr_alternatives.html

You won't be interested in all of it, but it does do a worked Log Miner demo, which might be enough to get you started. You will want to select SQL_REDO where TIMESTAMP between xxxx and yyyyy.

Regards
HJR
> I would
> like to use such a facility for testing purposes to ensure that only
> the updates I expected are actually taking place.
>
> Thanks
>
> Stuart Smith
Received on Thu Dec 09 2004 - 03:06:04 CST