Re: Accidentally dropped tables

Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1091800265.870872_at_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.

get a backup of what you have, before anything else is done. I would be worried about new segments re-using existing extents that used to belong to the now non-existent segments.

disconnecting it from the network comes to mind, as well as setting the following:

"SQL> alter system set job_queue_processes=0"
"SQL> alter system enable restricted session;"
"SQL> alter system suspsend;" 

support analysts are good at answering these types of questions.

-bdbafh Received on Fri Aug 06 2004 - 14:15:28 CDT