ORA-29857: domain indexes and/or secondary objects exist in the tablespace

在刪除tablespace的時候會出現錯誤：
SQL> drop tablespace K9EDM_DATA INCLUDING CONTENTS;
drop tablespace K9EDM_DATA INCLUDING CONTENTS
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace

 

Oracle docs note this about ORA-29857:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
Cause: An attempt was made to drop a tablespace which contains secondary objects and/or domain indexes.
Action: Drop the domain indexes in his tablespace. Also, find the domain indexes which created secondary objects in this tablespace and drop them. Then try dropping the tablespace.

可以執行以下命令，檢視該tablespace上的的index,刪除相關的index，然後就能刪除tablespace。
select index_name, table_owner, table_name, tablespace_name from user_indexes where index_type='DOMAIN';