Re: Dropping a 700 GB Tablespace in a Test Database Efficiently ?
- From: "Dennis Williams" <oracledba.williams@xxxxxxxxx>
- To: davidsharples@xxxxxxxxx
- Date: Mon, 23 Apr 2007 18:52:18 -0500
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
Other related posts:
