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';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30936525/viewspace-2016716/ ，如需转载，请注明出处，否则将追究法律责任。
