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-25010: Invalid nested table column name in nested table clause

1 Answers  


ORA-31211: DBMS_LDAP: PL/SQL - Invalid LDAP entry dn.

1 Answers  


ORA-28010: cannot expire external or global accounts

1 Answers  


ORA-36639: (XSDUNION18) UNIQUE cannot be applied to this concat dimension because leaves workspace object and workspace object share the value number.

1 Answers  


ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

1 Answers  






ORA-31112: fail to string for string port using xdb configuration

1 Answers  


ORA-30054: invalid upper limit snapshot expression

1 Answers  


ORA-22132: hexadecimal string does not correspond to a valid REF

1 Answers  


ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE

1 Answers  


DRG-10510: stopword is missing

1 Answers  


RMAN-06099: error occurred in source file: string, line: number

1 Answers  


ORA-02194: event specification syntax error string (minor error string) near 'string'

1 Answers  


Categories