Oracle Error Message
ORA-14404: partitioned table contains partitions in a different tablespace
Reason for the Error
An attempt was made to drop a tablespace which contains tables whose partitions are not completely contained in this tablespace
Solution
find tables with partitions which span the tablespace being dropped and some other tablespace(s). Drop these tables or move partitions to a different tablespace