Re: lost some data in table

Andrea wrote:
> Hi,
>
> a user tell me that has accidentally deleted some rows in a table, can
> i restore it with flashback area?
> how i restore it without stop the db?
>
> i've 10g DB rel.2 with archivelog and flashback enables.
>
> thanks for your support
>

Provided you have enough UNDO_RETENTION, you can use a Flashback Query to see the old data:

http://download-east.oracle.com/docs/cd/B19306_01/appdev.102/b14251/adfns_flashback.htm#sthref1458

If the Undo is lost, then Log Miner will work.

HTH,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown