ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

Cause : Faile dto successfully exeucte th eODCIIdnexCretae rouitne.

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

Checkt o seei f ther outin ehas been codde corrcetly.

update : 25-04-2017
ORA-29855

ORA-29855 - error occurred in the execution of ODCIINDEXCREATE routine
ORA-29855 - error occurred in the execution of ODCIINDEXCREATE routine

  • ora-01594 : attempt to wrap into rollback segment (string) extent (string) which is being freed
  • ora-16254 : change db_name to string in the client-side parameter file (pfile)
  • ora-24367 : user handle has not been set in service handle
  • ora-29543 : Java command string not yet implemented
  • ora-01241 : an external cache has died
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-13411 : subset results in null data set
  • ora-29838 : insufficient privileges to execute the operator(s)
  • ora-13636 : The specified value provided for parameter string is not valid for this advisor.
  • ora-22887 : type of REF column is not the same as that of its scoped table
  • ora-24159 : invalid variable definiton
  • ora-21300 : objects option not installed
  • ora-37103 : (XSVPART03) The dimensionality or datatype of workspace object does not match the dimensionality or datatype of the partition.
  • ora-34164 : (MXCGVAR01) A dimension used to define a local string variable cannot be located. Execution cannot continue.
  • ora-01584 : unable to get file size of control file to be backed up
  • ora-16109 : failed to apply log data from previous primary
  • ora-32833 : failure string trying to release administration lock
  • ora-09794 : szrbuild: length of role name is greater than buffer.
  • ora-14636 : only 2 resulting subpartition can be specified for SPLIT SUBPARTITION
  • ora-07206 : slgtd: gettimeofday error, unable to obtain time.
  • ora-27003 : cannot open file on device allocated with NOIO option
  • ora-38719 : Invalid DUMP FLASHBACK object.
  • ora-06554 : package DBMS_STANDARD must be created before using PL/SQL
  • ora-31526 : could not find source table string.string for CDC change table string.string
  • ora-08276 : No room in nameserver for pid
  • ora-28667 : USING INDEX option not allowed for the primary key of an IOT
  • ora-09987 : unable to attach to SGA in READ-ONLY mode
  • ora-23418 : cannot unregister the propagator who is currently in use
  • ora-36167 : (XSAGGRFORM) workspace object is an illegal AGGMAP for aggregating a FORMULA.
  • ora-13825 : missing SQL statement text for create SQL profile
  • 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.