Friends,
When i try to delete the tablespace(example) in 10gR2.
I am getting the below error.
I check the error message's solution but i dont know what to do?
SQL> DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE EXAMPLE INCLUDING CONTENTS AND DATAFILES
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
ORA-29857: domain indexes and/or secondary objects exist in the tablespace
Cause: An attempt was made to drop a tablespace which contains
secondary objects and/or domain indexes.
Action: 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.