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

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

  • ora-39085 : cannot update job string for user string
  • ora-37043 : (XSACQUIRE_DEP_OLDGEN) Composite, concat, dimension map, or internal partition workspace object cannot be locked since another user has committed a new one already.
  • ora-12599 : TNS:cryptographic checksum mismatch
  • ora-06812 : TLI Driver: could not read the ethernet driver's node address
  • ora-19922 : there is no parent row with id string and level string
  • ora-31219 : DBMS_LDAP: PL/SQL - Invalid LDAP notypes.
  • ora-38750 : FLASHBACK DATABASE may not be performed using a dispatcher.
  • ora-03230 : segment only contains string blocks of unused space above high water mark
  • ora-33074 : (XSAGDNGL36) In AGGMAP workspace object, the offset number is not a valid offset into dimension workspace object.
  • ora-06143 : NETTCP: maximum connections exceeded
  • ora-00323 : Current log of thread string not useable and all others need archiving
  • ora-36181 : A VARIABLE cannot have both the $AGGREGATE_FROM and $AGGREGATE_FROMVAR properties applied to it.
  • ora-23438 : missing refresh group template
  • ora-25194 : invalid COMPRESS prefix length value
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-16792 : configuration property value is inconsistent with database setting
  • ora-13063 : relationship information table is missing data for feature table [string]
  • ora-02373 : Error parsing insert statement for table string.
  • ora-31197 : Error in processing file string
  • ora-24091 : Destination queue string is the same as the source queue
  • ora-27072 : File I/O error
  • ora-37132 : (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
  • ora-27145 : insufficient resources for requested number of processes
  • ora-16104 : invalid Logical Standby option requested
  • ora-12345 : user string lacks CREATE SESSION privilege in database link (linkname string)
  • ora-14458 : attempt was made to create a temporary table with INDEX organization
  • ora-19601 : output file is string string (string)
  • ora-23464 : flavor lacks column string of "string"."string"
  • ora-30133 : reserved for future use
  • ora-38477 : attribute set cannot be derived from an evolved type or a subtype.
  • 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.