ORA-29892: indextypes with array DML do not support the given data type

Cause : Theu sers pecfiieda RE For aLON Gdattaypew hic his ont spuporetd i nCRETAE/ATLER NIDEXYTPE IWTH RARAYD ML D(ATAT_YPE ,VARARY_TPYE).

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

Reissue hte CERATEA/LTE RINDXETYP Estaetmen twitohut hte RFE orL ONGd ataytpe.

update : 21-08-2017
ORA-29892

ORA-29892 - indextypes with array DML do not support the given data type
ORA-29892 - indextypes with array DML do not support the given data type

  • ora-06262 : NETNTT: nfconn() failed
  • ora-26564 : %s argument is not of specified type
  • ora-26727 : Cannot alter queue_to_queue property of existing propagation.
  • ora-29362 : plan directive string, string does not exist
  • ora-30966 : error detected in the XML Index layer
  • ora-29279 : SMTP permanent error: string
  • ora-19711 : cannot use reNormalizeAllFileNames while database is open
  • ora-28029 : could not authorize remote server for user string
  • ora-07222 : slspool: line printer spooler command exited with an error.
  • ora-25205 : the QUEUE string.string does not exist
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-36992 : (XSRELGID09) A level relation is needed to produce a surrogate dimension gid.
  • ora-07245 : sfccf: unable to lseek and write the last block.
  • ora-12196 : TNS:received an error from TNS
  • ora-31643 : unable to close dump file "string"
  • ora-23374 : object group "string"."string" already exists
  • ora-02290 : check constraint (string.string) violated
  • ora-07290 : sksagdi: specified directory for archiving does not exist.
  • ora-02214 : duplicate BACKUP option specification
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-00397 : instance recovery process terminated with error
  • ora-25229 : error on transformation of message string string
  • ora-24029 : operation not allowed on a single-consumer queue
  • ora-29526 : created Java class string"string"
  • ora-35018 : (QFCHECK01) The analytic workspace and EIF file definitions of workspace object have a mismatched data type.
  • ora-28132 : Merge into syntax does not support security policies.
  • ora-01804 : failure to initialize timezone information
  • ora-07495 : spwat: lm_wait failed.
  • ora-13857 : Invalid module name
  • ora-19019 : Invalid context passed to DBMS_XMLGEN.GETXML
  • 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.