|
> ORA-29857: domain indexes and/or secondary objects exist in the tablespace
|
|
> select index_name, table_owner, table_name, tablespace_name from user_indexes where index_type=‘DOMAIN‘;
|
|
> ORA-29868: cannot issue DDL on a domain index marked as LOADING
|
|
> DROP INDEX <index_name> FROCE;
|
|
> select distinct owner from dba_tables where tablespace_name=‘<tablespace_name>‘
|
|
1
|
> ORA-29857: domain indexes and/or secondary objects exist in the tablespace |
|
1
|
> select index_name, table_owner, table_name, tablespace_name from user_indexes where index_type=‘DOMAIN‘; |
|
1
|
> ORA-29868: cannot issue DDL on a domain index marked as LOADING |
看样子这个就是导入时报错的地方，导致这个索引仍旧处在读取的状态，执行强制删除语句：
|
1
|
> DROP INDEX <index_name> FROCE; |
如果这样还不行，就重启数据库后再强制删除，然后再使用DROP语句删除表空间重建即可。
|
1
|
> select distinct owner from dba_tables where tablespace_name=‘<tablespace_name>‘ |
ORA-29857: domain indexes and/or secondary objects
原文：http://www.cnblogs.com/baiyangcao/p/5075211.html