ORA-29860: cannot truncate a table with domain indexes marked LOADING
What triggered the Error:
The table has domain indexes defined on it that are marked LOADING.What should we do to fix it:
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.