Drop Partition Problems

[lesstjm]

I have a problem dropping a partition. The partition is on a bad tablespace. The tablespace is missing a file. I just want to drop the tablespace (it has not data). I have to drop the partition first but it telling me I can't because I have a bad tablespace.

[davey23uk]

offline drop the datafile then delete the tablespace including contents and datafiles

[lesstjm]

SqlPlus>drop tablespace wtd_ts41 including contents and datafiles;
drop tablespace wtd_ts41 including contents and datafiles
*
ERROR at line 1:
ORA-14404: partitioned table contains partitions in a different tablespace

[lesstjm]

Is there a way to force a move partition?

I am getting an error trying to move the partition to another tablespace.

Once I do that I probably would be able to drop the tablespace.

[lesstjm]

I was able to solve my problem with Exchange Partition.

I created a temp table with the data I needed in a new tablespace.

Ran and exchange partition

Dropped the temp table

Dropped the bad tablespace

[ixion]

Was recovery not an option?

Good solution though.