drop tablespace xdb 出错了！

飞动的梦想

SQL>; drop tablespace xdb including contents;
drop tablespace xdb including contents
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace

怎么找到相关的domain indexes or secondary objects 并删除呢？？
谢谢！

doni

drop tablespace xdb including contents cacsade constraint;

cugdxp

// 1 alter tablespace tablespacename offline
// 2 drop  tablespace tablespacename  INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS

飞动的梦想

xdb是offline的,但依然不行啊,以上两种都试了一下,错误基本同!
SQL>; drop tablespace xdb including contents cascade constraint;
drop tablespace xdb including contents cascade constraint
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace