Re: Dropping a 700 GB Tablespace in a Test Database Efficiently ?

Vivek,

To me not having to perform a recovery because I assumed there was only one table in the tablespace, turns out I assumed wrong, is what I call efficient. So I would prefer to manually drop whatever contents there are, maybe exporting them just in case. Then drop the tablespaces (withOUT contents) and if I've overlooked something, I receive an error message.

Dennis Williams

--
http://www.freelists.org/webpage/oracle-l