Re: Generate undo information

On Mon, 17 Mar 2003 14:46:12 +0100, "Nick Wagner" <ni79_at_lycos.de> wrote:

>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
>

Look into using the dbms_logmnr package

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Mon Mar 17 2003 - 08:24:05 CST