Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Accidentally dropped tables

Re: Accidentally dropped tables

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 06 Aug 2004 06:50:27 -0700
Message-ID: <1091800265.870872@yasure>


Ted wrote:

> Thanks for the responses guys.  That is pretty much as I expected.
> 
> The software vendor that sold this particular application to my client
> has a DBA who is contacting me on Monday to try to save the data, if
> he is unsuccessful then I will most likely have to go the "send the
> drive to Oracle" route.
> 
> Thanks again and if you think of anything else I can try then please
> let me know.
> 
> Ted
> 
> tfrederick_at_ascentek.com (Ted) wrote in message news:<657748ae.0408051632.561cb8aa_at_posting.google.com>...
> 

>>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.

Most likely you won't be able to when he is done. Make sure that the DBA discusses what is intended with you first. That you then confirm with Oracle the chance of success. And only let him touch the box if convinced the chance of success are very very high.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Fri Aug 06 2004 - 08:50:27 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US