Re: Recovering dropped table from READONLY tablespace
- From: Jared Still <jkstill@xxxxxxxxx>
- To: Stephen.Barr@xxxxxxxxx
- Date: Mon, 14 Mar 2005 13:21:33 -0800
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
Other related posts:
