RE: Recovering dropped table from READONLY tablespace

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.
> -----------------------------------------------------------------------
> 
> --
> http://www.freelists.org/webpage/oracle-l
> 


-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: