It is temp Temp tablespace. Can drop/recreate temp tablespace easily?
It is a production system. Thanks as always.
Forgot to mention that it is Oracle 8i and datafile belongs to TEMP tablespace.
I can not recover that datafile.
Temporary tablespace TEMP or permanent tablespace TEMP :) Did you check all the "temporary" segments on that tablespace?
Dimitre
-- //www.freelists.org/webpage/oracle-l
-- //www.freelists.org/webpage/oracle-l