Oracle error ORA-29857:domain indexes and /or secondary objects exist in the tablespace
Posted on 2010-01-09
I am trying to drop a schema but am receiving Oracle error ORA-29857:domain indexes and /or secondary objects exist in the tablespace.
I ran a select index_name, table_ownder, table_name, tablespace_name
from all_indexes where index_type = 'DOMAIN';
Now am I suppose to delete those indexes? I am not sure why it won't let me just drop the schema. Shouldn't it automatically drop everything within the talespace
including indexes and other objects? Also just need the command to delete or drop the indexes