Recover deleted rows from a table from archive logs?

From: Snonck <snonck_at_snog.com>
Date: Thu, 26 Oct 2006 08:53:03 +1000
Message-ID: <453fea8c$0$5109$afc38c87_at_news.optusnet.com.au>

Is is possible to recover deleted rows from a table from archive logs?

For example, say you have a database with archive logging turned off. You create a table and populate it with records. You then reset the logs and place the database in archivelog mode.

Then you

delete from table;

commit;

Is the necessary information in the archive logs such that you can reconstruct the deleted rows from the table? Received on Thu Oct 26 2006 - 00:53:03 CEST