ORA-29857: Domain Indexes and/or Secondary Objects Exist in TS

[yongchoi75]

I'm getting below error message when I try to drop a XDB tablespace in 9i.

ORA-29857: Domain Indexes and/or Secondary Objects Exist in TS

I'm getting below error message when I try to drop a EXAMPLE tablespace in 9i.

ORA-23515: materialized views and/or their indices exist in the tablespace

How can I drop these tablespaces?
I don't need to keep these tablespaces right?

[Thomasps]

ORA-29857: Domain Indexes and/or Secondary Objects Exist in TS

Solution: There is an IOT is in the tableaspace. Drop that first before droping the tablespace

ORA-23515: materialized views and/or their indices exist in the tablespace

Drop the materialized views before droping the tablespace


Thomas

[yongchoi75]

Ok, I was able to drop XDB Tablespaces by dropping user XDB. How can I drop EXAMPLE Tablespaces? Which user is using EXAMPLE Tablespaces? Which Dictionary View can I query to retrieve the Materialized view info?

[Thomasps]

select object_name,owner
from dba_objects
where object_type='UNDEFINED';


Thomas