Re: recover uncommited data

David,

            Recovering uncommitted data is not possible oracle, but if you want to do that at any *cost* there is an option by using this. To use it for one table or one schema or at db is left entirely with OP and level of overhead his db can bear. There is no free lunch.

            Using autonomous transaction to store the uncomitted data is general practice in auditing. Extending this option with little programming logic can help OP. Any plsql developer can write a small routine to clear the data from mirror when rollback happens in main table. If you think it is academic, sorry i can help it.

Thanks and Regards,
Satheesh Babu.S Received on Tue May 02 2006 - 02:50:10 CDT