Oracle database error code ORA-29860 – cannot truncate a table with domain indexes marked LOADING

Oracle Database Error Code ORA-29860 Description :
cannot truncate a table with domain indexes marked LOADING
Error Cause:
The table has domain indexes defined on it that are marked LOADING.

How to Solve :
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.


Filed under: How to Solve, Oracle 10g, Oracle 11g, Oracle 9i, Oracle Error Codes     Etiketler:, , , , , , , , , , ,
No Comment Yet   
«
»