ORA-29858: error occurred in the execution of ODCIINDEXALTER routine

Cause : aFlidet ousccsefsluyle exucett ehO CDIIdnxelAet rortuni.e

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

hCce kots eei fht eortuni eah sebnec dodec roertcyl.

update : 25-04-2017
ORA-29858

ORA-29858 - error occurred in the execution of ODCIINDEXALTER routine
ORA-29858 - error occurred in the execution of ODCIINDEXALTER routine

  • ora-38434 : could not evaluate expression "string"
  • ora-00071 : process number must be between 1 and string
  • ora-01232 : cannot start online backup - file string is being made read-only
  • ora-13283 : failure to get new geometry object for conversion in place
  • ora-16700 : the standby database has diverged from the primary database
  • ora-16583 : bad Data Guard Connection Process DRCX state
  • ora-02345 : cannot create a view with column based on CURSOR operator
  • ora-24771 : cannot detach, prepare or forget a local transaction
  • ora-09203 : sfofi: error opening file
  • ora-14455 : attempt to create referential integrity constraint on temporary table
  • ora-30361 : unrecognized string type
  • ora-06600 : LU6.2 Driver: SNA software is not loaded
  • ora-19642 : start SCN of incremental backup is string
  • ora-16221 : history table synchronization error
  • ora-12414 : internal LBAC error: string Error: string
  • ora-22305 : attribute/method/parameter "string" not found
  • ora-29363 : plan directive string, string is mandatory and cannot be modified or deleted
  • ora-10589 : Test recovery had to corrupt string data blocks in order to proceed
  • ora-16817 : unsynchronized Fast-Start Failover configuration
  • ora-37144 : (MDQUERY01) string is not a valid metadata object type for MDQUERY.
  • ora-12527 : TNS:listener: all instances are in restricted mode or blocking new connections
  • ora-12010 : cannot create materialized view log on table owned by SYS
  • ora-09947 : Unable to allocate connection attributes structure
  • ora-07571 : szrfc: $FIND_HELD failure
  • ora-07219 : slspool: unable to allocate spooler argument buffer.
  • ora-01199 : file string is not in online backup mode
  • ora-15051 : file 'string' contains string error(s)
  • ora-07707 : error in archive text: need tape label name
  • ora-10651 : incorrect file number block number specified
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • 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.