Unfortunately not. However, I believe I have a dump from a while ago (this tablespace was transported from another DB). I'll give that a try and hope it works! Thanks all. Steve. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Jared Still Sent: 14 March 2005 21:22 To: Stephen.Barr@xxxxxxxxx Cc: oracle-l@xxxxxxxxxxxxx Subject: Re: Recovering dropped table from READONLY tablespace I think this is the salient point from the docs: Caution: You cannot roll back a DROP TABLE statement. Recovery of this table requires a restore. Do you have a backup? On Mon, 14 Mar 2005 19:48:39 -0000, Barr, Stephen <Stephen.Barr@xxxxxxxxx> wrote: > 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. > ----------------------------------------------------------------------- > > -- > //www.freelists.org/webpage/oracle-l > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l