Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 16003 invoked from network); 13 Jul 2007 12:56:14 -0500 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by 69.64.49.119 with SMTP; 13 Jul 2007 12:56:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E3CA9713024; Fri, 13 Jul 2007 13:53:45 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16981-01; Fri, 13 Jul 2007 13:53:45 -0400 (EDT) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4C487712FF1; Fri, 13 Jul 2007 13:53:45 -0400 (EDT) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 13 Jul 2007 13:12:35 -0400 (EDT) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id B28007132AE for ; Fri, 13 Jul 2007 13:12:35 -0400 (EDT) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 01904-06 for ; Fri, 13 Jul 2007 13:12:35 -0400 (EDT) Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.168]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 06FCA7132AC for ; Fri, 13 Jul 2007 13:12:32 -0400 (EDT) Received: by ug-out-1314.google.com with SMTP id o4so682118uge for ; Fri, 13 Jul 2007 10:14:39 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:from:to:cc:references:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=BO7YEy8E7TkvdIrSMVu3pmBn971a1VfmrYHJ1BBhSH/vNnvgAho9MNvgbbI5CLGPS5EEHhu8CUMF/+hYSJdFY23nDM56SLvwyLqF+5+Nf2twrmpOycP4kCogXJJnuquOyDqWr4EY3tHVZLd5IdJtM1ybK9gQUeVMdcAAS8h4Kds= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:from:to:cc:references:subject:date:mime-version:content-type:x-priority:x-msmail-priority:x-mailer:x-mimeole; b=ELQavIGn3h9DNVL967p/oLSZx/pPLAsVKALs3Mr/Rt8nM7YnHuMm3wFL56Z6cLq63cMhcdgCYbEARcQsfk0jLSrtyzV1K+mCWYjG59SDnRhP1Tss3br2bmTrZZiLIYimT92pTGWKUGR/3QI/gAf38Ajbqp+srnDbfhVMYerXU2g= Received: by 10.86.95.20 with SMTP id s20mr1443360fgb.1184346878469; Fri, 13 Jul 2007 10:14:38 -0700 (PDT) Received: from ltbir ( [84.150.109.11]) by mx.google.com with ESMTP id p9sm3345691fkb.2007.07.13.10.14.35 (version=SSLv3 cipher=RC4-MD5); Fri, 13 Jul 2007 10:14:37 -0700 (PDT) Message-ID: <006f01c7c571$3f2564a0$9f00a8c0@ltbir> From: "Robert Bialek" To: , "Kerber, Andrew W." Cc: "oracle-l" References: <537415.34704.qm@web32614.mail.mud.yahoo.com> Subject: Re: undrop?? Date: Fri, 13 Jul 2007 19:14:16 +0200 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_006C_01C7C582.0140E900" X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3138 X-archive-position: 50862 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: bialekr@gmail.com Precedence: normal Reply-to: bialekr@gmail.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------=_NextPart_000_006C_01C7C582.0140E900 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Have a look at DUDE: http://www.ora600.nl/introduction.htm ----- Original Message -----=20 From: John D Parker=20 To: Kerber, Andrew W. ; oracle-l=20 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." 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@freelists.org = [mailto:oracle-l-bounce@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=20 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=20 "just hacking datafile headers... to recover the unrecoverable..."=20 =20 -------------------------------------------------------------------------= --- 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. = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D -------------------------------------------------------------------------= ----- Need a vacation? Get great deals to amazing places on Yahoo! Travel. ------=_NextPart_000_006C_01C7C582.0140E900 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Have a look at DUDE:
 
http://www.ora600.nl/intro= duction.htm
----- Original Message -----
From:=20 John = D Parker=20
To: Kerber, Andrew W. ; oracle-l=20
Sent: Friday, July 13, 2007 = 5:54 PM
Subject: RE: undrop??

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

John

"Kerber, = Andrew W."=20 <Andrew.Kerber@umb.com>=20 wrote:
Seems = like there=20 was some discussion a while back about a tool oracle has that will = do this.=20 I don=92t recall the name though..
 
-----Original=20 Message-----
From: oracle-l-bounce@freelists.o= rg=20 [mailto:oracle-l-bounce@freelists.org] On=20 Behalf Of John D Parker
Sent: Friday, July 13, 2007 = 10:30=20 AM
To: = oracle-l
Subject: = undrop??
 
anyone know how to undrop = objects after=20 a bugger'd recovery, system tablespace is from after datafile. = objects are=20 not defined in obj$. all blocks in needed datafile show up in=20 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=20
after my herculean effort = yesterday to=20 hack datafiles and get this database open, I'd sure like to be able = to get=20 data out of it...
followup related question, = When oracle=20 drops a table, the entry is removed from obj$ and all the proper = changes are=20 made to UET$ and FET$. The question is, for security purposes are = the blocks=20 zeroed or scrambled or just marked as dropped? This is version=20 9.2.0.6.
John =
"just hacking datafile = headers... to=20 recover the unrecoverable..."
 
Don't pick lemons.
See = all the new=20 2007 cars at Yahoo!=20 Autos.
=
--------------------------------------------------------------------= ----------
NOTICE:=20 This electronic mail message and any attached files are = confidential. The=20 information is exclusively for the use of the individual or entity = intended=20 as the recipient. If you are not the intended recipient, any use, = copying,=20 printing, reviewing, retention, disclosure, distribution or = forwarding of=20 the message or any attached file is not authorized and is strictly=20 prohibited. If you have received this electronic mail message in = error,=20 please advise the sender by reply electronic mail immediately and=20 permanently delete the original transmission, any attachments and = any copies=20 of this message from your computer system. Thank=20 = you.

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D

Need a vacation? Get=20 great deals to amazing places on Yahoo! Travel. = ------=_NextPart_000_006C_01C7C582.0140E900-- -- http://www.freelists.org/webpage/oracle-l