ORA-29868: cannot issue DDL on a domain index marked as LOADING

Cause : Tire dt oissu eaD RPO/LATRE/RTUCNAET no admoani nidxe ni aLAODNIGs ttae.

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

Wiatt ill htei nedxo preaito ncmopeltse RO siseu aDORPI NEDXF OCREt od rpo htei nedx.

update : 27-04-2017
ORA-29868

ORA-29868 - cannot issue DDL on a domain index marked as LOADING
ORA-29868 - cannot issue DDL on a domain index marked as LOADING

  • ora-24366 : migratable user handle is set in service handle
  • ora-19017 : Attributes can only be simple scalars
  • ora-32106 : array fetch not allowed without setBuffer on all columns
  • ora-16581 : Data Guard NetSlave failed to send message to DRCX
  • ora-01882 : timezone region string not found
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-13779 : invalid load option
  • ora-16516 : the current state is invalid for the attempted operation
  • ora-02309 : atomic NULL violation
  • ora-12648 : Encryption or data integrity algorithm list empty
  • ora-22062 : invalid input string [string]
  • ora-22851 : invalid CHUNK LOB storage option value
  • ora-07277 : spdde: illegal pid passed as argument.
  • ora-01212 : MAXLOGMEMBERS may not exceed string
  • ora-30502 : system triggers cannot have INSERT, UPDATE, or DELETE as triggering events
  • ora-36986 : (XSRELGID05) Relation workspace object must be dimensioned by workspace object.
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-27154 : post/wait create failed
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-01224 : group number in header string does not match GROUP string
  • ora-01685 : max # extents (string) reached in index string.string partition string
  • ora-12834 : Instance group name, 'string', too long, must be less than string characters
  • ora-00306 : limit of string instances in this database
  • ora-07258 : spdcr: fork error, unable to create process.
  • ora-13415 : invalid or out of scope point specification
  • ora-31160 : max substitution group size string exceeded by "string" (string) for head element "string" (string)
  • ora-23606 : invalid object string
  • ora-02474 : Fixed hash area extents used (string) exceeds maximum allowed (string)
  • ora-39112 : Dependent object type string skipped, base object type string creation failed
  • ora-03252 : initial extent size not enough for LOB segment
  • 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.