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.
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