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 Secondary Objects exists in Tablespace

AKPTFeb 27 2012 — edited Feb 27 2012

Database:10.2.0.4
OS:Windows

While dropping tablespace I'm getting ORA-29857.
I understand that i have to drop domain indexes on tablespace and also find secondary objects in this tablespace and drop them.

Kindly provide me step by step troubleshooting(query) for this error.

Thanks,
Alok

This post has been answered by unknown-7404 on Feb 27 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 26 2012

Added on Feb 27 2012

#general-database-discussions

2 comments

1,150 views