Re: Recovering Dropped Tables with no Backup

"Tom Holden" <tholden8_at_hotmail.com> 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

I don't think I'd employ him.
Backups are rather a good idea. If you don't take them, you don't have a lot of options.

Paul Received on Sun Sep 22 2002 - 14:01:31 CDT