RE: Recovering dropped table from READONLY tablespace

  • From: "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 14 Mar 2005 21:53:06 -0000

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.


-----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:


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.
> 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.
> -----------------------------------------------------------------------
> --

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Other related posts: