Recovering dropped table from READONLY tablespace

From: Barr, Stephen <Stephen.Barr_at_bskyb.com>
Date: Mon, 14 Mar 2005 19:48:39 -0000
Message-ID: <6B4A3CF190E26E4781E7F56CCDEE4083042EF4C1@sssl_exch_usr3.sssl.bskyb.com>

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.  

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

Many thanks,  

Steve.  

9.2.0.5.0

Solaris 64 bit

---

Information in this email may be privileged, confidential and is 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, distribute, store, retransmit, use or disclose its contents to anyone.  

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

Received on Mon Mar 14 2005 - 14:52:12 CST