ORA-29902: error in executing ODCIIndexStart() routine

Cause : The eexcutio nof ODICIndextSart ruotine acused na erro.r

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

Examien the reror msesagesp roducde by teh indetxype cdoe andt ake appropritae actoin.

update : 22-07-2017
ORA-29902

ORA-29902 - error in executing ODCIIndexStart() routine
ORA-29902 - error in executing ODCIIndexStart() routine

  • ora-01743 : only pure functions can be indexed
  • ora-00830 : cannot set statistics_level to BASIC with auto-tune SGA enabled
  • ora-27200 : skgfpgo: sbtpcstart returned error
  • ora-16708 : the state supplied to resource guard is invalid
  • ora-00232 : snapshot control file is nonexistent, corrupt, or unreadable
  • ora-12634 : Memory allocation failed
  • ora-09957 : Unable to send termination request to IMON
  • ora-32022 : parameter value longer than string characters
  • ora-28501 : communication error on heterogeneous database link
  • ora-09300 : osncon: unable to connect, DPMI not available
  • ora-37111 : Unable to load the OLAP API sharable library: (string)
  • ora-01113 : file string needs media recovery
  • ora-31023 : Index size error
  • ora-09791 : slembdf: translation error, unable to translate error file name.
  • ora-32624 : illegal reordering of MODEL dimensions
  • ora-27211 : Failed to load Media Management Library
  • ora-27543 : Failed to cancel outstanding IPC request
  • ora-19376 : no privileges on tablespace provided or tablespace is offline
  • ora-15168 : rolling downgrade prevented by string
  • ora-33094 : (XSAGGMAPLIST01) Your expression uses too much execution space. Eliminate recursion or reduce the levels of nesting.
  • ora-12916 : Cannot use default permanent tablespace with this release
  • ora-39962 : invalid parameter for PLSQL_CCFLAGS
  • ora-09321 : slzdtb: unable to convert zoned decimal to binary
  • ora-10635 : Invalid segment or tablespace type
  • ora-33022 : (XSAGDNGL10) The measure dimension workspace object must be a TEXT or ID base dimension that does not dimension AGGMAP workspace object, but is in the same analytic workspace.
  • ora-13615 : The task or object string is greater than the maximum allowable length of 30 characters.
  • ora-27086 : unable to lock file - already in use
  • ora-01070 : Using an old version of Oracle for the server
  • ora-23374 : object group "string"."string" already exists
  • ora-23618 : Generation of script string is not complete.
  • 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.