RE: undrop??

From: John D Parker <orclwzrd_at_yahoo.com>
Date: Fri, 13 Jul 2007 08:54:40 -0700 (PDT)
Message-ID: <537415.34704.qm@web32614.mail.mud.yahoo.com>

Thanks!
Yes, Oracle has DUL, data unloader, and there are a couple of other companies also.

John

"Kerber, Andrew W." <Andrew.Kerber_at_umb.com> 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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Jul 13 2007 - 10:54:40 CDT