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 : 20-08-2017
ORA-29858

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

  • ora-33468 : (ESDREAD13) Discarding compiled code for workspace object because number is no longer a surrogate of dimension workspace object.
  • ora-33922 : (MAKEDCL35) You cannot define a surrogate of dimension workspace object because it is a time dimension.
  • ora-19922 : there is no parent row with id string and level string
  • ora-39064 : unable to write to the log file
  • ora-30679 : JDWP-based debugging not supported in this configuration
  • ora-22329 : cannot alter a non-object type
  • ora-16578 : failed to read Data Guard configuration file
  • ora-12925 : tablespace string is not in force logging mode
  • ora-37023 : (XSMLTUPD01) Object workspace object cannot be updated without dimension workspace object.
  • ora-30741 : WITH HIERARCHY OPTION can be specified only for SELECT privilege
  • ora-24276 : function 'string' output 'string' maximum value exceeded
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-06127 : NETTCP: unable to change username
  • ora-25278 : grantee name cannot be NULL
  • ora-16644 : apply instance not available
  • ora-24758 : not attached to the requested transaction
  • ora-08189 : cannot flashback the table because row movement is not enabled
  • ora-06710 : TLI Driver: send interrupt break message failed
  • ora-30506 : system triggers cannot be based on tables or views
  • ora-25299 : Invalid message delivery_mode
  • ora-00359 : logfile group string does not exist
  • ora-27431 : chain string.string has a user-managed rule set
  • ora-23478 : object group "string" is already mastered at string
  • ora-12437 : invalid policy option: string
  • ora-39027 : wrong version of master table
  • ora-13750 : User "string" has not been granted the "ADMINISTER SQL TUNING SET" privilege.
  • ora-12086 : table "string"."string" is not an object table
  • ora-28332 : cannot have more than one password for the encryption key
  • ora-13425 : function not implemented
  • ora-19114 : error during parsing the XQuery expression: string
  • 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.