Re: undrop??
- From: "Robert Bialek" <bialekr@xxxxxxxxx>
- To: <orclwzrd@xxxxxxxxx>, "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- Date: Fri, 13 Jul 2007 19:14:16 +0200
Have a look at DUDE:
http://www.ora600.nl/introduction.htm
----- Original Message -----
From: John D Parker
To: Kerber, Andrew W. ; oracle-l
Sent: Friday, July 13, 2007 5:54 PM
Subject: RE: undrop??
Thanks!
Yes, Oracle has DUL, data unloader, and there are a couple of other companies
also.
John
"Kerber, Andrew W." <Andrew.Kerber@xxxxxxx> wrote:
Seems like there was some discussion a while back about a tool oracle has
that will do this. I don't recall the name though..
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of John D Parker
Sent: Friday, July 13, 2007 10:30 AM
To: oracle-l
Subject: undrop??
anyone know how to undrop objects after a bugger'd recovery, system
tablespace is from after datafile. objects are not defined in obj$. all blocks
in needed datafile show up in dba_free_space. The system tablespace is from
after the drop and the datafile in question is from before the drop.
version is 9.2.0.6
after my herculean effort yesterday to hack datafiles and get this database
open, I'd sure like to be able to get data out of it...
followup related question, When oracle drops a table, the entry is removed
from obj$ and all the proper changes are made to UET$ and FET$. The question
is, for security purposes are the blocks zeroed or scrambled or just marked as
dropped? This is version 9.2.0.6.
John
"just hacking datafile headers... to recover the unrecoverable..."
----------------------------------------------------------------------------
Don't pick lemons.
See all the new 2007 cars at Yahoo! Autos.
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are
confidential. The information is exclusively for the use of the individual or
entity intended as the recipient. If you are not the intended recipient, any
use, copying, printing, reviewing, retention, disclosure, distribution or
forwarding of the message or any attached file is not authorized and is
strictly prohibited. If you have received this electronic mail message in
error, please advise the sender by reply electronic mail immediately and
permanently delete the original transmission, any attachments and any copies of
this message from your computer system. Thank you.
==============================================================================
------------------------------------------------------------------------------
Need a vacation? Get great deals to amazing places on Yahoo! Travel.
Other related posts:
