Discussions
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
Database 11.2.0.4
I'm trying to drop a tablespace but it says domain indexes or secondary objects exist. But when I query for these, it shows none. What am I missing? How do I determine what is stopping me from dropping the tablespace?
-------------------------------------------------------------------------------------------------
SQL>DROP TABLESPACE APPS_TS_TX_DATA INCLUDING CONTENTS;
DROP TABLESPACE APPS_TS_TX_DATA INCLUDING CONTENTS
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
SQL>SELECT OWNER,INDEX_NAME, TABLE_OWNER, TABLE_NAME
2 FROM DBA_INDEXES WHERE INDEX_TYPE='DOMAIN'
3 AND TABLESPACE_NAME ='APPS_TS_TX_DATA';
no rows selected
SQL>SELECT INDEX_NAME,I.TABLE_NAME FROM DBA_INDEXES I, DBA_TABLES T