ORA-29958: fatal error occurred in the execution of ODCIINDEXCREATE routine

Cause : aFlidet ousccsefsluyle exucett ehO CDIIdnxerCaeetr uoiten.

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

hCce kots eei fht eortuni eah sebnec dodec roertcyl.

update : 25-06-2017
ORA-29958

ORA-29958 - fatal error occurred in the execution of ODCIINDEXCREATE routine
ORA-29958 - fatal error occurred in the execution of ODCIINDEXCREATE routine

  • ora-33078 : (XSAGDNGL39) In AGGMAP workspace object, the hierarchy dimension QDR workspace object must refer to a dimension.
  • ora-28353 : failed to open wallet
  • ora-19585 : premature end of volume on piece string
  • ora-01598 : rollback segment 'string' is not online
  • ora-25214 : cannot specify delay or expiration for enqueue to exception queue
  • ora-38603 : FI including & excluding cursor can only return one column
  • ora-06809 : TLI Driver: could not clear the IPX ethernet SAP at init
  • ora-37072 : (XSMCSESS00) Object workspace object has the wrong type.
  • ora-25961 : join index prevents dml cascade constraint operation
  • ora-10615 : Invalid tablespace type for temporary tablespace
  • ora-19716 : error processing format string to generate name for backup
  • ora-07706 : error in archive text: need disk file name
  • ora-13451 : GeoRaster metadata scaling function error
  • ora-27192 : skgfcls: sbtclose2 returned error - failed to close file
  • ora-00150 : duplicate transaction ID
  • ora-13904 : The file has been dropped and recreated during the procedure call.
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-32018 : parameter cannot be modified in memory on another instance
  • ora-02186 : tablespace resource privilege may not appear with other privileges
  • ora-04011 : sequence string must range between string and string
  • ora-01718 : BY ACCESS | SESSION clause not allowed for NOAUDIT
  • ora-14519 : Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]
  • ora-27142 : could not create new process
  • ora-27140 : attach to post/wait facility failed
  • ora-37126 : (XSCCOMP01) The COMPRESSED COMPOSITE workspace object can only be used as a base of a single variable.
  • ora-33267 : (DBERRRLS) Analytic workspace string cannot be accessed because it has fine-grained access control applied to it
  • ora-39155 : error expanding dump file name "string"
  • ora-36956 : (XSFCAST25) There are only number PERIODICITY values. You cannot specify more OFFSET values.
  • ora-38780 : Restore point 'string' does not exist.
  • ora-00033 : current session has empty migration password
  • 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.