Re: Deleted Tables

From: Michael S. Abbey <masint_at_istar.ca>
Date: Tue, 14 Apr 1998 00:09:51 GMT
Message-ID: <3532a911.1098078@news.istar.ca>

On Mon, 13 Apr 1998 21:42:01 GMT, john_at_demon.co.uk (jk) wrote:

>Anybody know how to recover a table that has been accidentally dropped.
>It is possible cos I've seen it done before but cant remember how we did it.

If your database is running in ARCHIVELOG mode, perhaps you can perofrm incomplete media recovery, and stop just before the table was dropped. You can also recover from a recent export, keeping in mind that the restoration will not reflect any transactions since the export was created.

Michael

+------------------------------------
+  Michael S. Abbey    Ottawa Canada
+  Co-author of Oracle8: A Beginner's Guide

+ and 5 other works in the Oracle Press Series

+------------------------------------

Received on Mon Apr 13 1998 - 19:09:51 CDT