Oracle DB Error ORA-29860 cannot truncate a table with domain indexes marked LOADING

Oracle DB Error ORA-29860 cannot truncate a table with domain indexes marked LOADING

The following is the cause of this error:

The table has domain indexes defined on it that are marked LOADING.

Action you can take to resolve this issue: 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.


Tags: Database, Microsoft, Oracle, SQL, Software, DBMS, Error Messages, Directory




Disclaimer:Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Related

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-16 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution