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

有时候，我们在删除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啦。

To identify the indexes of the domain, try executing,

select index_name, table_owner, table_name, tablespace_name from user_indexes where index_type='DOMAIN';

The tablespace may not be specified, but you could at least see the potential indexes.  Remember that you should be connected with an index user status to run the above query.  If this is not possible, try ALL_INDEXES in place of USER_INDEXES,

select owner, index_name, table_owner, table_name, tablespace_name from all_indexes where index_type='DOMAIN';

参考：

http://www.dba-oracle.com/sf_ora_29857_domain_indexes_and_or_secondary_objects_exist_in_the_tablespace_bc1.htm