Oracle Error Message
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
Reason for the Error
An attempt was made to drop a tablespace which contains secondary objects and/or domain indexes.
Solution
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.