On Mon, 16 Sep 2002 10:29:43 -0400, Sybrand Bakker wrote:
> tholden8_at_hotmail.com (Tom Holden) wrote in message
> news:<13773e73.0209160219.2afcfbc5_at_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
>
>
> This is exactly why one should make recurring exports.
Even for an instance with ARCHIVELOG mode on?
Received on Mon Sep 16 2002 - 18:11:51 CDT
