ORA-29952: cannot issue DDL on a domain index partition marked as LOADING ORACLE 报错 故障修复 远程处理
文档解释
ORA-29952: cannot issue DDL on a domain index partition marked as LOADING
Cause: Tried to issue a DROP/ALTER/TRUNCATE on a domain index partition in a LOADING state.
Action: Wait till the index partition operation completes OR issue a DROP INDEX FORCE to drop the index OR issue a ALTER TABLE DROP PARTITION to drop the partition.
ORA-29952: cannot issue DDL on a domain index partition marked as LOADING错误提示某个索引分区正处于Loading状态，当前无法对其执行DDL语句。官方解释指出，由于该分区仍处在Loading中，因此不能进行修改操作，需要等到Loading完成才能进行DDL操作。
常见情况：当创建索引非常大时，可能会出现这种情况，当前它正处于Loading的状态，防止改变当前的行为，因此不能执行DDL操作。
