Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center