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 : 23-05-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-24343 : user defined callback error
  • ora-38717 : Invalid DUMP FLASHBACK option.
  • ora-00486 : ASMB process terminated with error
  • ora-26059 : Data is too large for column string
  • ora-06321 : IPA: Cannot reach the remote side
  • ora-01870 : the intervals or datetimes are not mutually comparable
  • ora-29549 : class string.string has changed, Java session state cleared
  • ora-16019 : cannot use string with LOG_ARCHIVE_DEST or LOG_ARCHIVE_DUPLEX_DEST
  • ora-01980 : error during OS ROLE initialization
  • ora-35024 : (QFCHECK04) The analytic workspace and EIF file definitions of workspace object have mismatched time dimension attributes.
  • ora-30016 : undo tablespace 'string' is already in use by this instance
  • ora-19554 : error allocating device, device type: string, device name: string
  • ora-00298 : Missing or invalid attribute value
  • ora-39774 : parse of metadata stream failed with the following error: string
  • ora-06734 : TLI Driver: cannot connect
  • ora-25256 : consumer cannot be specified with a single-consumer queue or an exception queue
  • ora-10691 : Set background process core file type (Unix only)
  • ora-36951 : (XSFCAST28) The ALLOCLAST parameter cannot be set to YES unless PERIODICITY specifies more than one cycle.
  • ora-38412 : Expression set column string does not exist.
  • ora-31046 : Incorrect argument(s) specified in the operator
  • ora-24340 : cannot support more than 255 columns
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-37129 : (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.
  • ora-02718 : osnprs: reset protocol error
  • ora-31217 : DBMS_LDAP: PL/SQL - Invalid LDAP newparent.
  • ora-07850 : sllfop: bad option
  • ora-23368 : name string cannot be null or the empty string
  • ora-22952 : Nested Table equality requires a map method on the element ADT
  • ora-16172 : archive logs detected beyond Terminal End-Of-Redo
  • ora-06622 : LU6.2 Driver: Unable to attach to SNA
  • 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.