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.