Re: Generate undo information

From: makbo <makbo_at_pacbell.net>
Date: Wed, 26 Mar 2003 14:43:19 GMT
Message-ID: <3E81BC86.50009@pacbell.net>

If you are using Oracle 9i, you might also consider versioned tables via the Workspace manager. From OEM documentation,

"Workspaces can be merged or rolled back. Merging a workspace involves applying changes made in a workspace to its parent workspace[...].Rolling back a workspace involves deleting either all the changes made in the workspace or all changes made after a savepoint (that is, an explicit savepoint). "

If you don't have DBA access to your production system, the DBA should be more directly involved in this effort.

Daniel Roy wrote:

> 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 Wed Mar 26 2003 - 08:43:19 CST