Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Generate undo information
Log miner gives you this, or you may wish to look at auditing insert/update
for the duration of the deployment.
The cheap mans option would be to export the schema and keep the export.
-- Niall Litchfield Oracle DBA Audit Commission UK "Nick Wagner" <ni79_at_lycos.de> wrote in message news:b54jj5$mcl$1_at_linux1.netconx.de...Received on Mon Mar 17 2003 - 08:25:54 CST
> 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
>
>