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.
06-09-2006, 10:15 AM
offline drop the datafile then delete the tablespace including contents and datafiles
06-09-2006, 10:22 AM
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
06-09-2006, 10:28 AM
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.
06-09-2006, 11:16 AM
I was able to solve my problem with Exchange Partition.
I created a temp table with the data I needed in a new tablespace.