ORA-29878: warning in the execution of ODCIINDEXTRUNCATE routine

Cause : A wranin gwasr etunred rfom hte OCDIInedxTrnucat erouitne.

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

Chekc tos ee fi th erouitne ahs been cdoed ocrretcly hCeckt he suer edfinde wanringl og atble sforg reaetr dteail.s

update : 23-06-2017
ORA-29878

ORA-29878 - warning in the execution of ODCIINDEXTRUNCATE routine
ORA-29878 - warning in the execution of ODCIINDEXTRUNCATE routine

  • ora-24753 : local transactions cannot be detached
  • ora-12214 : TNS:missing local communities entry in TNSNAV.ORA
  • ora-13052 : unsupported geometric type for geometry string.string
  • ora-12057 : materialized view "string"."string" is INVALID and must complete refresh
  • ora-31027 : Path name or handle string does not point to a resource
  • ora-19372 : invalid update condition
  • ora-25268 : didnt dequeue in browse mode with get signature option
  • ora-02309 : atomic NULL violation
  • ora-28172 : distinguished name not provided by proxy
  • ora-13367 : wrong orientation for interior/exterior rings
  • ora-01184 : logfile group string already exists
  • ora-31079 : unable to resolve reference to string "string"
  • ora-04032 : pga_aggregate_target must be set before switching to auto mode
  • ora-13335 : LRS measure information not defined
  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-24418 : Cannot open further sessions.
  • ora-31102 : Already locked in exclusive mode. Cannot add lock.
  • ora-00070 : command string is not valid
  • ora-24159 : invalid variable definiton
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-16826 : apply service state is inconsistent with the DelayMins property
  • ora-16028 : new string causes less destinations than LOG_ARCHIVE_MIN_SUCCEED_DEST requires
  • ora-02247 : no option specified for ALTER SESSION
  • ora-12476 : least upper bound resulted in an invalid OS label
  • ora-28153 : Invalid client initial role specified: 'string'
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-14512 : cannot perform operation on a clustered object
  • ora-25235 : fetched all messages in current transaction
  • ora-16031 : parameter string destination string exceeds string character limit
  • ora-16796 : one or more properties could not be imported from the database
  • 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.