ORA-14405: partitioned index contains partitions in a different tablespace

oerr ora 14405
14405, 00000, "partitioned index contains partitions in a different tablespace"
// *Cause: An attempt was made to drop a tablespace which contains indexes
// whose partitions are not completely contained in this tablespace,
// and which are defined on the tables which are completely contained
// in this tablespace.
// *Action: find indexes with partitions which span the tablespace being
// dropped and some other tablespace(s). Drop these indexes, or move
// the index partitions to a different tablespace, or find the tables
// on which the indexes are defined, and drop (or move) them.

查询 dba_segments中，表空间 xxx 已经没有存储任何对象.
select segment_name,segment_type from dba_segments where tablespace_name='xxx';

然后查询 dba_ind_partitions 中，又能看到一个分区索引还在表空间中.
select index_name,index_owner from dba_ind_partitions where tablespace_name='xxx';

再次重建该分区索引
select partition_name from dba_segments where segment_name='xxx';
alter index idx_xxx rebuild partition xxx_000 tablespace users;
select index_name,index_owner from dba_ind_partitions where tablespace_name='xxx';

再次 drop 表空间以及数据文件
drop tablespace xxx including contents and datafiles;

------------------
方法1：
exec dbms_tts.transport_set_check('PART4_NDX_TS',incl_constraints => true,full_check => true);
select * from transport_set_violations;

根据结果，删除对应索引
drop index SCOTT.EMPLOYEE_IND_DEPTNO;

select owner,constraint_name,constraint_type,table_name,status from dba_constraints where index_name in (select index_name from dba_indexes where tablespace_name=upper('tools'));

alter table owner.table_name disable constraint constraint_name;