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 : 20-08-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-36712 : (XSMXALLOC02) Relation workspace object must be a one-dimensional self-relation to be used as a SOURCE or BASIS with ALLOCATE.
  • ora-22288 : file or LOB operation string failed string
  • ora-12416 : policy string not found
  • ora-17621 : failed to register the memory with Oracle Disk Manager library
  • ora-29833 : indextype does not exist
  • ora-27158 : process control failure
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-14020 : this physical attribute may not be specified for a table partition
  • ora-25125 : BUFFER_POOL storage option not allowed
  • ora-00090 : failed to allocate memory for cluster database ORADEBUG command
  • ora-01619 : thread string is mounted by another instance
  • ora-09976 : skxfqdini: Error Creating Port
  • ora-16528 : unable to allocate PGA heap
  • ora-32163 : Method called on Invalid Environment type
  • ora-14460 : only one COMPRESS or NOCOMPRESS clause may be specified
  • ora-31509 : publication does not exist
  • ora-02043 : must end current transaction before executing string
  • ora-04020 : deadlock detected while trying to lock object stringstringstringstringstring
  • ora-01223 : RESETLOGS must be specified to set a new database name
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-22634 : Error adding new instance to AnyDataSet
  • ora-26737 : version string already has an export dump file
  • ora-13467 : unsupported GeoRaster metadata specification: string
  • ora-01155 : the database is being opened, closed, mounted or dismounted
  • ora-30960 : The entity is neither an XPATH nor a NAMESPACE.
  • ora-14030 : non-existent partitioning column in CREATE TABLE statement
  • ora-32121 : Source FILE is null
  • ora-10931 : trace name context forever
  • ora-08434 : raw data has invalid trailing sign
  • ora-38479 : creation of system trigger EXPFIL_RESTRICT_TYPEEVOLVE failed
  • 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.