文档解释
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操作。