Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Recovering Deleted Record

Re: Recovering Deleted Record

From: Jose Nicolau <jose.nicolau_at_clix.pt>
Date: Fri, 30 Mar 2001 22:21:35 -0500
Message-ID: <3AC54D3F.26F86901@clix.pt>

Even if you are in noarchive log mode:

1. backup your actual database
2. restore a backup database before the mistake
3. delete all the rows from the table, except the row deleted
4. export the table
5. restore the actual database
6. import the table

It's hard but runable... :)

Stan Powers wrote:

> How is it possible to recover a record deleted accidentally? Is this
> information stored in the Redo logs? Or a Audit Log?
>
> Is there a way that I can configure my database so that it maintains a log,
> and copy for that matter, of all deleted records?
>
> Thanks, Stan.
  Received on Fri Mar 30 2001 - 21:21:35 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US