Re: recover uncommited data

From: <fitzjarrell_at_cox.net>
Date: 1 May 2006 08:20:54 -0700
Message-ID: <1146496854.005327.17610@e56g2000cwe.googlegroups.com>

Satheesh Babu.S wrote:
> Hi,
> You can't recover uncommitted data. But there is one more option
> which you can try.
> Create a trigger with autonomous transaction on this table and populate
> to other similar table. If you want to recover the data after abort you
> can take populate from this new table.
>
> Thanks and Regards,
> Satheesh Babu.S

How does that apply to the OP's original question? How does that 'recover' these 'transactions' during startup? The original post is shown below:

" I had some prob. in my database so I shutdown abort Now while starting database I need to recover uncommited data also.

HOW............................."

Your suggestion applies to one table of his choice, not all; how does that recover 'uncommitted data' for every transaction running at the time of the failure? I fail to see how your 'solution' is applicable to this situation. Possibly you can enlighten us all?

David Fitzjarrell Received on Mon May 01 2006 - 10:20:54 CDT