ITPub博客

首页 > 数据库 > Oracle > ORA-29857: domain indexes and/or secondary objects exist in the tablespace

ORA-29857: domain indexes and/or secondary objects exist in the tablespace

Oracle 作者:urgel_babay 时间:2016-02-29 17:29:48 0 删除 编辑

在删除tablespace的时候会出现错误:
SQL> drop tablespace K9EDM_DATA INCLUDING CONTENTS;
drop tablespace K9EDM_DATA INCLUDING CONTENTS
*
ERROR at line 1:
ORA-29857: domain indexes and/or secondary objects exist in the tablespace

 

Oracle docs note this about ORA-29857:
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.

可以执行以下命令,查看该tablespace上的的index,删除相关的index,然后就能删除tablespace。
select index_name, table_owner, table_name, tablespace_name from user_indexes where index_type='DOMAIN';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/30936525/viewspace-2016716/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-02-29

  • 博文量
    203
  • 访问量
    215024