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

PLS-00514: INSERT statement with REF INTO clause requires a typed table

1 Answers  


DGM-16901: Unable to initialize environment

1 Answers  


ORA-35071: (QFHEAD06) EIF file string cannot be imported because analytic workspace string has not been upgraded to version string.

1 Answers  


ORA-38402: invalid name: empty string or spaces in the name

1 Answers  


TNS-00277: Navigator: Request Failed

1 Answers  






ORA-29540: class string does not exist

1 Answers  


PLS-01413: Use of NULL an expression

1 Answers  


ORA-07241: slemrd: read error.

1 Answers  


RMAN-06421: sent command to channel: string

1 Answers  


ORA-38444: statistics do not exist for the expression set

1 Answers  


TNS-00021: INTCTL: missing INTERCHANGE_DATA in INTCHG.ORA

1 Answers  


NPL-00413: incoming ASN.1 encoding has length string, maximum allowed is string

1 Answers  


Categories