Re: undrop??

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: