Hi,
Due to APPS_TS_TX_IDX tablespace have some datafile missed, I had move/rebuild already to new tablespace APPS_TS_TX_IDX_UP (except Temporary).
When I try to drop tablespace APPS_TS_TX_IDX, Error with ORA-29857 exist as below, please help to investigate, thanks.
FYI:
SQL> select sum(bytes/1024/1024),segment_type,count(*) from dba_segments where tablespace_name ='APPS_TS_TX_IDX' group by segment_type;
SUM(BYTES/1024/1024) SEGMENT_TYPE COUNT(*)
-------------------- ------------------ ----------
126431 TEMPORARY 1207
SQL> DROP TABLESPACE APPS_TS_TX_IDX INCLUDING CONTENTS AND DATAFILES cascade constraints ;
DROP TABLESPACE APPS_TS_TX_IDX INCLUDING CONTENTS AND DATAFILES cascade constraints
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace