RE: undrop??
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: orclwzrd@xxxxxxxxx, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 13 Jul 2007 10:49:38 -0500
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
<http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE0OGRsc3F2BF9TAzk3MTA3M
Dc2BHNlYwNtYWlsdGFncwRzbGsDbmV3Y2Fycw--> at Yahoo! Autos.
<http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE0OGRsc3F2BF9TAzk3MTA3M
Dc2BHNlYwNtYWlsdGFncwRzbGsDbmV3Y2Fycw-->
------------------------------------------------------------------------------
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.
==============================================================================
Other related posts:
