Re: Generate undo information

Sybrand Bakker wrote:
> 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

Thanks for the quick response. I already considered using dbms_logmnr package, but we do not have dba access to the database in the production system, can't set/change utl_file_dir etc. Therefore we can't use it.

Is there no easier way? Received on Mon Mar 17 2003 - 08:36:39 CST