Wednesday 16 May 2012

ORA-29860: cannot truncate a table with domain indexes marked LOADING

ORA-29860: cannot truncate a table with domain indexes marked LOADING

Cause: The table has domain indexes defined on it that are marked LOADING.

Action: Wait to see if the ongoing index DDL ends and the index state changes from LOADING state. Else ,drop the domain indexes marked as LOADING with the FORCE option.

No comments:

Post a Comment