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 : 24-04-2017

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

  • ora-12467 : minimum label can contain a level only
  • ora-23416 : table "string"."string" does not contain a primary key constraint
  • ora-37073 : (XSMCSESS01) Applied relation workspace object must be dimensioned by dimension workspace object.
  • ora-01500 : failure in getting date/time
  • ora-13520 : Database id (string) not registered, Status = string
  • ora-32801 : invalid value string for string
  • ora-00028 : your session has been killed
  • ora-02831 : Segment deallocation failed - empty segment list
  • ora-29529 : invalid function or method call string in trigger string
  • ora-01588 : must use RESETLOGS option for database open
  • ora-01258 : unable to delete temporary file string
  • ora-30941 : Cannot specify empty URI for non-default namespace 'string'
  • ora-16743 : the status of redo transport service for standby database "string" is unknown
  • ora-22984 : view query cannot contain references to a super view
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property name.
  • ora-12031 : cannot use primary key columns from materialized view log on "string"."string"
  • ora-12822 : duplicate option in PARALLEL clause
  • ora-32616 : missing DIMENSION BY keyword in MODEL clause
  • ora-23616 : Failure in executing block string for script string
  • ora-22991 : insufficient space allocated for argument string
  • ora-03277 : invalid SIZE specified
  • ora-16654 : Fast-Start Failover is enabled
  • ora-30447 : internal data for run number string is inconsistent
  • ora-14104 : RECOVERABLE/UNRECOVERABLE may not be specified for partitioned tables/indices
  • ora-28660 : Partitioned Index-Organized table may not be MOVEd as a whole
  • ora-16233 : The table string.string is unsupported now
  • ora-01248 : file string was created in the future of incomplete recovery
  • ora-16148 : user requested expiration of managed recovery operation
  • ora-01344 : LogMiner coordinator already attached
  • ora-16646 : Fast-Start Failover is disabled
  • 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.