Re: Accidentally dropped tables

Ted wrote:

> Greetings:
>
> I am in a bit of a pickle here.
>
> One of my employees accidentally dropped some if not all of a
> customers tables in an Oracle 8.1 database while following some
> questionable instructions from the software vendor.
>
> It does not appear as though archive logging is happenning and the
> most recent dump I can find is from around January 9.
>
> Do I have any options here for recovering this data or "undoing" the
> drop?
>
> Any and all assistance is much appreciated as I am FAR from being a
> DBA.
>
> Thanks.

Assuming what you are saying is correct.

1. Pull the hard disk out of the machine.
2. Put it into a box.
3. Contact Oracle and find out what it is going to cost you to have it recovered.

Based on everything you've said my guess is that you are more likely to make things worse rather than better.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)