ORA-29865: indextype is invalid

Cause : The indextype is invalid.

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

Drop and recreate the indextype.

update : 28-07-2017
ORA-29865

ORA-29865 - indextype is invalid
ORA-29865 - indextype is invalid

  • ora-31153 : Cannot create schema URL with reserved prefix "http://xmlns.oracle.com/xdb/schemas/"
  • ora-23405 : refresh group number string does not exist
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-35276 : (SNSYN163) The format of the ALLOCATE command is: ALLOCATE varname [SOURCE svarname] [BASIS bvarname [ACROSS dimname]] [TARGET tvarname [TARGETLOG logvarname]] [ USING aggmap ]
  • ora-22627 : tc [string] must be that of object/varray/nested table
  • ora-03252 : initial extent size not enough for LOB segment
  • ora-15032 : not all alterations performed
  • ora-31487 : cannot support begin dates or end dates in this configuration
  • ora-37601 : (XSPGERRTEMP) Ran out of temporary storage while writing to analytic workspace with ID=number. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.
  • ora-08266 : create_ora_addr: cannot register name in nameserver
  • ora-09832 : infoCallback: bad message format.
  • ora-02876 : smpini: Unable to attach to shared memory for PGA
  • ora-06920 : CMX: getbrkmsg illegal datatype
  • ora-25465 : variable name not specified
  • ora-13183 : unsupported geometric type for geometry string.string
  • ora-38621 : Decision Tree maximum depth setting not between [2, 20]
  • ora-17509 : Attempt to do i/o beyond block1 offset
  • ora-37143 : (XSSQLMDQ03) string is not a valid analytic workspace name.
  • ora-24762 : server failed due to unspecified error
  • ora-06129 : NETTCP: unable to transfer socket ownership to ORASRV
  • ora-29534 : referenced object string.string could not be resolved
  • ora-28591 : agent control utility: unable to access parameter file
  • ora-15123 : ASM file name 'string' contains an invalid incarnation number
  • ora-27212 : some entrypoints in Media Management Library are missing
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-07638 : smsget: SGA pad area not large enough for created SGA
  • ora-22923 : amount of data specified in streaming LOB write is 0
  • ora-33290 : (DBERR17) Analytic workspace string cannot be attached in the mode you requested because another user has it attached in an incompatible mode.
  • ora-07681 : sou2os: An error occurred while initializing Oracle
  • ora-16147 : standby database referenced by multiple archive log destinations
  • 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.