ORA-29859: error occurred in the execution of ODCIINDEXTRUNCATE routine

Cause : aFlidet ousccsefsluyle exucett ehO CDIIdnxerTnuacetr uoiten.

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

hCce kots eei fht eortuni eah sebnec dodec roertcyl.

update : 24-04-2017
ORA-29859

ORA-29859 - error occurred in the execution of ODCIINDEXTRUNCATE routine
ORA-29859 - error occurred in the execution of ODCIINDEXTRUNCATE routine

  • ora-12597 : TNS:connect descriptor already in use
  • ora-10561 : block type 'string', data object# string
  • ora-16564 : lookup failed, syntax error at string
  • ora-00089 : invalid instance number in ORADEBUG command
  • ora-01313 : LogMiner dictionary column type different from specified type
  • ora-30157 : An invalid argument was given to operating system call
  • ora-02038 : define is not allowed for array type
  • ora-36830 : (XSLMGEN00) AW name cannot be NA
  • ora-02758 : Allocation of internal array failed
  • ora-03290 : Invalid truncate command - missing CLUSTER or TABLE keyword
  • ora-29286 : internal error
  • ora-02420 : missing schema authorization clause
  • ora-16104 : invalid Logical Standby option requested
  • ora-24011 : cannot drop QUEUE, string should be stopped first
  • ora-07485 : scg_get_inst: cannot open instance number lock.
  • ora-01664 : Transaction which has expanded the Sort Segment has aborted
  • ora-40252 : no target values were found
  • ora-06448 : ssvpstp: Failed with unexpected error number.
  • ora-09838 : removeCallback: failure removing the callback port.
  • ora-07562 : sldext: extension must be 3 characters
  • ora-39147 : cannot migrate Data Pump queue table ownership to this instance
  • ora-16777 : unable to find the destination entry of a standby database in V$ARCHIVE_DEST
  • ora-28554 : pass-through SQL: out of cursors
  • ora-02040 : remote database string does not support two-phase commit
  • ora-06929 : CMX: error when sending ORACLE_SID
  • ora-32305 : RepAPI materialized views with user-defined types are not supported
  • ora-01412 : zero length not allowed for this datatype
  • ora-12716 : Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
  • ora-24750 : incorrect size of attribute
  • ora-36402 : (XSSPROP03) The property '$string' requires a leading "$" because it is a system-reserved property 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.