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