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

Oracle Error Message

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

Reason for the Error

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

Solution

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.