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 : 23-06-2017
ORA-29858

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

  • ora-14263 : new subpartition name must differ from that of any other subpartition of the object
  • ora-14400 : inserted partition key does not map to any partition
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-36154 : (XSMXAGGR01) workspace object is not a data variable.
  • ora-39052 : cannot specify SKIP_CURRENT on initial start of a job.
  • ora-12059 : prebuilt table "string"."string" does not exist
  • ora-04043 : object string does not exist
  • ora-09937 : Chmod of ORACLE password file failed.
  • ora-22150 : variable-length array has not been initialized
  • ora-14281 : CHECK constraint mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-00290 : operating system archival error occurred. See error below
  • ora-13783 : invalid tuning scope
  • ora-13855 : Tracing for service (module/action) string on instance string is already enabled
  • ora-40212 : invalid target data type in input data for string function
  • ora-38797 : Full database recovery required after a database has been flashed back
  • ora-39081 : failed to unsubscribe agent string from queue "string"
  • ora-06266 : NETNTT: bad write length
  • ora-06741 : TLI Driver: unable to open protocol device
  • ora-22878 : duplicate LOB partition or subpartition specified
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-29903 : error in executing ODCIIndexFetch() routine
  • ora-29825 : invalid name for indextype
  • ora-40252 : no target values were found
  • ora-12235 : TNS:Failure to redirect to destination
  • ora-01340 : NLS error
  • ora-01930 : auditing the object is not supported
  • ora-32613 : not a MODEL cell
  • ora-14261 : partition bound may not be specified when adding this Hash partition
  • ora-06251 : NETNTT: cannot translate address file name
  • 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.