Re: reverse update statement

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 17 Oct 2005 19:09:05 -0700
Message-ID: <1129601342.71156@yasure>

epipko_at_gmail.com wrote:
> Hi all,
> We are on Oracle 9.2/Win2003.
> Someone updated 20000 recods in d/base and want to find out what rows
> were updated. That user didn't use mod_by, so there is no trail. Undo
> retention is set to 90 min only, so that is not an option. What are my
> options?
>
> Thanks,
> Eugene

That undo retention was set to 90 minutes does not mean that undo information might now exist going back far futher. Look, for example, at DBMS_FLASHBACK and see what is possible.

Also making the use of mod_by optional is a design issue that should be addressed as soon as possible. Perhaps you need a good DBA. ;-)

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Mon Oct 17 2005 - 21:09:05 CDT