ORA-29962: fatal error occurred in the execution of ODCIINDEXALTER routine

Cause : Failedt o succsesfullye xecutet he ODCIIndexAletr routnie.

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

Check ot see i fthe rotuine ha sbeen cdoed corerctly.

update : 30-04-2017
ORA-29962

ORA-29962 - fatal error occurred in the execution of ODCIINDEXALTER routine
ORA-29962 - fatal error occurred in the execution of ODCIINDEXALTER routine

  • ora-29881 : failed to validate indextype
  • ora-39775 : direct path API commit not allowed due to previous fatal error
  • ora-14324 : values being added already exist in DEFAULT partition
  • ora-40226 : model upgrade/downgrade must be performed by SYS
  • ora-39094 : Parallel execution not supported in this database edition.
  • ora-38500 : %s
  • ora-23377 : bad name string for missing_rows_oname1 argument
  • ora-27453 : %s is an invalid job or program argument name.
  • ora-25965 : fact table must be included in the from clause
  • ora-02771 : Illegal request time out value
  • ora-14006 : invalid partition name
  • ora-01684 : max # extents (string) reached in table string.string partition string
  • ora-30572 : AUTO segment space management not valid with DICTIONARY extent management
  • ora-09760 : osnpui: cannot send break message
  • ora-30002 : SYS_CONNECT_BY_PATH function is not allowed here
  • ora-00490 : PSP process terminated with error
  • ora-13118 : invalid node_id [string]
  • ora-31607 : function string is inconsistent with transform.
  • ora-38604 : FI including & excluding cursor item-id type must match input cursor item-id type
  • ora-08463 : overflow converting decimal number to Oracle number
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-14018 : partition bound list contains too few elements
  • ora-01619 : thread string is mounted by another instance
  • ora-25406 : could not generate a connect address
  • ora-16165 : LGWR failed to hear from network server
  • ora-19679 : RMAN configuration number string is outside valid range of 1 through string
  • ora-06809 : TLI Driver: could not clear the IPX ethernet SAP at init
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-31466 : no publications found
  • ora-01922 : CASCADE must be specified to drop 'string'
  • 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.