-
ORA-29857: Domain Indexes and/or Secondary Objects Exist in TS
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?
-
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
-
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?
-
select object_name,owner
from dba_objects
where object_type='UNDEFINED';
Thomas
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|