Recovering dropped table from READONLY tablespace
- From: "Barr, Stephen" <Stephen.Barr@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 14 Mar 2005 19:48:39 -0000
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
Other related posts:
