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.
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
Other related posts:
