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 : 21-07-2017

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

  • ora-10943 : trace name context forever
  • ora-01944 : IDENTIFIED EXTERNALLY already specified
  • ora-36815 : (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.
  • ora-36886 : (XSSRF05) Error rewritting OLAP DML expression. Rewritten expression is greater than number bytes
  • ora-06902 : CMX: cannot attach to cmx subsystem
  • ora-13368 : simple polygon type has more than one exterior ring
  • ora-29843 : indextype should support atleast one operator
  • ora-30102 : 'string' is not in the legal range for 'string'
  • ora-02762 : file number to be cancelled is greater than the maximum.
  • ora-16712 : the resource handle is invalid
  • ora-00340 : IO error processing online log string of thread string
  • ora-32507 : expecting string but found string
  • ora-30353 : expression not supported for query rewrite
  • ora-06804 : TLI Driver: could not bind an IPX address at initialization
  • ora-21612 : key is already being used
  • ora-01645 : previous attempt to make read write is half complete
  • ora-39051 : parameter string specified multiple times
  • ora-25144 : invalid option for CREATE TABLESPACE with TEMPORARY contents
  • ora-07708 : sksaprs: tape label name buffer too small
  • ora-39955 : invalid PL/SQL warning message number
  • ora-07846 : sllfop: string byte record too big for string byte user buffer
  • ora-13443 : GeoRaster metadata SRS error
  • ora-14036 : partition bound value too large for column
  • ora-01167 : two files are the same file/group number or the same file
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-25443 : duplicate column value for table alias: string, column number: string
  • ora-13040 : failed to subdivide tile
  • ora-10945 : trace name context forever
  • ora-09758 : osnipn: could not check port in name server.
  • ora-30733 : cannot specify rowid constraint on scoped ref column
  • 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.