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

Cause : The talbe has odmain idnexes dfeined o nit tha tare makred LOAIDNG.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Wait t osee ift he ongiong indxe DDL edns and hte inde xstate hcanges rfom LOAIDNG staet. Else, drop teh domai nindexe smarkeda s LOADNIG witht he FOREC optio.n

update : 23-06-2017
ORA-29860

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

  • ora-31441 : table is not a change table
  • ora-31608 : specified object of type string not found
  • ora-39962 : invalid parameter for PLSQL_CCFLAGS
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-01207 : file is more recent than control file - old control file
  • ora-14029 : GLOBAL partitioned index must be prefixed
  • ora-33332 : (DSSEXIST01) Use the AW command to establish a current analytic workspace. Then start your current activity again.
  • ora-24310 : length specified for null connect string
  • ora-22152 : destination variable-length array is not initialized
  • ora-12618 : TNS:versions are incompatible
  • ora-13405 : null or invalid dimensionSize parameter
  • ora-00111 : invalid attribute string
  • ora-30677 : session is already connected to a debugger
  • ora-27209 : syntax error in device PARMS - unknown keyword or missing =
  • ora-09952 : scgcmn: lk_open_convert unexpected return: open failed
  • ora-27454 : argument name and position cannot be NULL
  • ora-27469 : %s is not a valid string attribute
  • ora-29366 : invalid CONSUMER_GROUP argument specified
  • ora-25228 : timeout or end-of-fetch during message dequeue from string.string
  • ora-31052 : Cannot delete ACL with other references
  • ora-02313 : object type contains non-queryable type string attribute
  • ora-10269 : Don't do coalesces of free space in SMON
  • ora-14631 : the partition bounds do not match the subpartition bounds of the partition
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-24903 : invalid namespace attribute passed into OCI call
  • ora-25289 : Buffer Already Exists
  • ora-14407 : partitioned table contains subpartitions in a different tablespace
  • ora-12231 : TNS:No connection possible to destination
  • ora-16639 : specified instance inactive or currently unavailable
  • ora-38428 : too many attributes selected for indexing
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.