Quote Originally Posted by PAVB
(*) only exception is when some or the partitions of a partitioned object are sitting in target tablespace but not all of them. If this is the case -thanks god- Oracle would refuse to drop the tablespace .
i wonder why, when it can drop dependent structures, why not this?

Rgds
Abhay.