RE: Recovering dropped table from READONLY tablespace

From: Scott Hutchinson <scott.hutchinson_at_interact-analysis.com>
Date: Mon, 14 Mar 2005 21:20:01 -0000
Message-ID: <005b01c528db$9682cab0$0100a8c0@INTERACT>

Steve,

If the tablespace is still read-only, you can drop the tablespace (drop tablespace XXX including contents) and re-import all meta-data (assuming = you
still have the dump file). This will re-instate the dropped table, = along
with all other objects that are in the tablespace. Probably a bit of a sledge-hammer approach, but it should work.

Scott Hutchinson
Interact Analysis Ltd.

-----Original Message-----
From: oracle-l-bounce_at_freelists.org =
[mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Barr, Stephen
Sent: 14 March 2005 19:49
To: oracle-l_at_freelists.org
Subject: Recovering dropped table from READONLY tablespace

Hi,

   A table within one of our readonly tablespaces was dropped. I can see the table has been "renamed" to a numeric value and still exists in DBA_SEGMENTS, but it's definition has been dropped from the dictionary.
=20

   Is there any way that we can recover this data from this temporary segment back into the table?
=20

Many thanks,
=20

Steve.
=20

9.2.0.5.0

Solaris 64 bit

---

Information in this email may be privileged, confidential and is=20 intended exclusively for the addressee. The views expressed may not be official policy, but the personal views of the originator. If you have received it in error, please notify the sender by return e-mail and delete it from your system. You should not reproduce,=20 distribute, store, retransmit, use or disclose its contents to anyone.
=20

Please note we reserve the right to monitor all e-mail communication through our internal and external networks.

---

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

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

Received on Mon Mar 14 2005 - 16:23:34 CST