Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Recovering dropped table from READONLY tablespace

RE: Recovering dropped table from READONLY tablespace

From: Barr, Stephen <Stephen.Barr_at_bskyb.com>
Date: Mon, 14 Mar 2005 21:53:06 -0000
Message-ID: <6B4A3CF190E26E4781E7F56CCDEE4083042EF4C7@sssl_exch_usr3.sssl.bskyb.com>


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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Jared Still
Sent: 14 March 2005 21:22
To: Stephen.Barr_at_bskyb.com
Cc: oracle-l_at_freelists.org
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_at_bskyb.com> 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
Received on Mon Mar 14 2005 - 16:56:40 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US