RE: Recovering dropped table from READONLY tablespace

If the tablespace is still read-only, you can drop the tablespace (drop
tablespace XXX including contents) and re-import all meta-data (assuming =
you
still have the dump file). This will re-instate the dropped table, =
along
with all other objects that are in the tablespace. Probably a bit of a
sledge-hammer approach, but it should work.

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

Is there any way that we can recover this data from
this temporary segment back into the table?
=20

Many thanks,
=20

Steve.
=20

9.2.0.5.0

Solaris 64 bit

Information in this email may be privileged, confidential and is=20
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,=20
distribute, store, retransmit, use or disclose its contents to anyone.
=20

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.