SQL> DROP tablespace SUMM_DATA07;
DROP tablespace SUMM_DATA07
                *
ERROR at line 1:
ORA-14404: partitioned TABLE contains partitions IN a different tablespace appears.
 
SQL> ALTER TABLE CCDAWORK.S_ACCT_FIX DROP partition P6;
ALTER TABLE CCDAWORK.S_ACCT_FIX DROP partition P6
                                               *
ERROR at line 1:
ORA-14117: partition resides IN offlined tablespace

SELECT owner,segment_name, partition_name,segment_type
FROM dba_segments
WHERE segment_type='TABLE PARTITION' AND 
tablespace_name IN(list of the offlined tablespces IN upper case)
ORDER BY segment_name;

CREATE TABLE TEMP AS SELECT * FROM OWNER.SEGMENT_NAME 
WHERE 1=2;

ALTER TABLE OWNER.SEGMENT_NAME 
exchange partition PARTITION_NAME WITH TABLE TEMP;

DROP TABLE TEMP;