Re: Recovering Deleted Record

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