ORA-29864: analyzing domain indexes marked LOADING/FAILED not supported

Cause : Tride toa nalzye ad omani inedx wihch aws mrakeda s LAODIN Gor AFILE.D

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

If hte idnex aws mrakedL OADNIG, awit itll ti ism arkde vaild bfeorer etriyng hte aanlyz.e Ifi nde xwasm arkde FALIED,d ropi t O Rrebiuld ti an dretyr th eanaylze.

update : 25-09-2017
ORA-29864

ORA-29864 - analyzing domain indexes marked LOADING/FAILED not supported
ORA-29864 - analyzing domain indexes marked LOADING/FAILED not supported

  • ora-31612 : Allocation of process descriptor failed.
  • ora-19504 : failed to create file "string"
  • ora-09945 : Unable to initialize the audit trail file
  • ora-02172 : The PUBLIC keyword is not appropriate for a disable thread
  • ora-13455 : GeoRaster metadata TRS error
  • ora-16735 : error executing dbms_logstdby.unskip_error procedure
  • ora-12636 : Packet send failed
  • ora-38771 : unnamed datafile(s) added to control file by flashback recovery
  • ora-13143 : invalid POLYGON window definition
  • ora-02295 : found more than one enable/disable clause for constraint
  • ora-39032 : function string is not supported in string jobs
  • ora-14055 : keyword REBUILD in ALTER INDEX REBUILD must immediately follow
  • ora-25326 : Array string operation failed for message at index string
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-13606 : the specified task parameter element string is out of range for parameter string.
  • ora-26736 : Data Pump error
  • ora-00352 : all logs for thread string need to be archived - cannot enable
  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-12231 : TNS:No connection possible to destination
  • ora-01283 : Options specified is invalid
  • ora-13123 : invalid name specified
  • ora-13341 : a line geometry has fewer than two coordinates
  • ora-12467 : minimum label can contain a level only
  • ora-07474 : snclrd: close error, unable to close sgadef.dbf file.
  • ora-12712 : new character set must be a superset of old character set
  • ora-36848 : (XSLMGEN18) Dimension string.string!string is missing a COLUMNNAME property value
  • ora-25132 : UNIQUE constraint (string.string) disabled and validated in ALTER TABLE EXCHANGE PARTITION
  • ora-31637 : cannot create job string for user string
  • ora-32621 : illegal aggregation in UNTIL iteration condition
  • ora-19124 : fn:one-or-more() called with a sequence containing no items
  • 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.