Re: Generate undo information

Why not increase UNDO_RETENTION accordingly (if you have the extra space to do so)? You then wouldn't need to code anything. If you can't do this, I can't think of anything besides the Log Miner which could help you store and retrieve the undo info.

Daniel

"Nick Wagner" <ni79_at_lycos.de> wrote in message news:<b54jj5$mcl$1_at_linux1.netconx.de>...
> We want to generate "undo information" for DML-Statements by our own and
> store the data somewhere (e.g. in a table).
>
> Background: During a software deployment we have to insert/update records in
> the database. The requirement is, that an undo of the software deployment
> can happen in a later stage (database changes already commited).
> Therefore all information to undo database changes have to be stored. These
> information should be generated, not coded by a developer.
> Is there anything that gives me the corresponding undo statement for a DML?
>
> How can we do this, any advises?
>
> Thanks in advance, Nick
Received on Mon Mar 17 2003 - 15:07:32 CST