Drop Partition Problems
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.
offline drop the datafile then delete the tablespace including contents and datafiles
Still Have Error
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
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.
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
Was recovery not an option?
Good solution though.