Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: lost some data in table
Brian Peasland wrote:
> 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.
>
thanks very much! Received on Wed Oct 25 2006 - 02:52:23 CDT