ORA-29857: 網域索引和 (或) 次要物件存在於表格空間中

刪除 tablespace時出現 ORA-29857: 網域索引和 (或) 次要物件存在於表格空間中 ORA-29857: domain indexes and/or secondary objects exist in the tablespace

$sqlplus "/as sysdba"
SQL> select owner||','||index_name||','||table_owner from all_indexes where index_type='DOMAIN';
OWNER||','||INDEX_NAME||','||TABLE_OWNER
GSUSER,IDX_PTY_INDI_P_NAME,GSUSER
GSUSER,IND_PTY_ORG__CTXCAT,GSUSER

SQL>drop user gsuser cascade;
User droped.
SQL>drop tablespace GS_342_INIT_TBS including contents cascade constraints;
Tablespace dropped.