Recovering Dropped Tables with no Backup

From: Tom Holden <tholden8_at_hotmail.com>
Date: 16 Sep 2002 03:19:33 -0700
Message-ID: <13773e73.0209160219.2afcfbc5@posting.google.com>

In NOARCHIVELOG mode, Suppose you have no Backups (Cold or Hot) and a user drops a table. How can we recover the table? I would think not. Someone asked me this question and he said he had been told in an interview that it can be done.

As far as i know, drop and truncate information is not stored in redolog files.... So Logminer should not help... Am i wrong?

Also drop and truncate information is not stored in RBS, so even with 9i Flashback dropped tables cannot be recovered. Am i wrong?

Is there some way a dropped table can be recovered?

Thanks for any clarification,
Tom Received on Mon Sep 16 2002 - 05:19:33 CDT