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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More Oracle Errors Interview Questions

ORA-23488: propagation mode "string" for "string" is not allowed for this operation

1 Answers  


ORA-22326: cannot change a type to FINAL if it has subtypes

1 Answers  


ORA-12522: TNS:listener could not find available instance with given INSTANCE_ROLE

1 Answers  


ORA-31104: Cannot find lock with token "string" on "string" for unlock

1 Answers  


ORA-26517: materialized view control entry for 'string.string' was not found

1 Answers  






ORA-16779: The destination parameter of some database has wrong syntax.

1 Answers  


NNL-00261: Request forwarding is currently enabled

1 Answers  


RMAN-20298: DBMS_RCVCAT package not compatible with the recovery catalog

1 Answers  


ORA-19032: Expected XML tag string got string

1 Answers  


O2F-00333: An unexpected token appeared where a keyword was expected in the INTYPE file

1 Answers  


TNS-12638: Credential retrieval failed

1 Answers  


ORA-06037: NETDNT: connect failed, node unreachable

1 Answers  


Categories