Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

776040May 29 2010 — edited Feb 7 2013

I tried to drop tablespace APPS_TS_TX_DATA using drop tablespace APPS_TS_TX_DATA including contents and datafiles cascade constraints.
I got error ORA-29857: domain indexes and/or secondary objects exist in the tablespace.
After I have dropped all domain indexes, then tried to drop tablespace again, I still got the same error. I have searched metalink regarding this error, there is no hit.
What exactly objects in the tablespace are prevenng dropping the tablespaces?

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 7 2013

Added on May 29 2010

#general-database-discussions

21 comments

12,979 views