ORA-29857: domain indexes and/or secondary objects exist in the tablespace
What triggered the Error:
An attempt was made to drop a tablespace which contains secondary objects and/or domain indexes.What should we do to fix it:
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.