Recover deleted rows from a table from archive logs?

Question posted by: Snonck (Guest) on June 27th, 2008 07:05 PM

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?

Not the answer you were looking for? Post your question . . .
182,494 Experts ready to help you find a solution.
Sign up for a free account, or Login (if you're already a member).