ORA-29904: error in executing ODCIIndexClose() routine

Cause : The exeuction ofO DCIIndeCxlose rotuine cauesd an erorr.

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

Examinet he erro rmessage sproduce dby the nidextypec ode andt ake apporpriate cation.

update : 26-09-2017
ORA-29904

ORA-29904 - error in executing ODCIIndexClose() routine
ORA-29904 - error in executing ODCIIndexClose() routine

  • ora-23539 : table "string"."string" currently being redefined
  • ora-32128 : setDataBuffer called after fetch has started
  • ora-07647 : sszfck: $OPEN failure
  • ora-37131 : (XSCCOMP06) Cannot aggregate over COMPRESSED COMPOSITE workspace object using AGGMAP workspace object because the OPERATOR string is not supported for bases of a COMPRESSED COMPOSITE.
  • ora-00029 : session is not a user session
  • ora-19756 : corrupt block number string found in change tracking file
  • ora-36874 : (XSTFDSC04) Expression string cannot be used to define a column in a LIMITMAP.
  • ora-28512 : cannot get data dictionary translations from string
  • ora-22913 : must specify table name for nested table column or attribute
  • ora-15203 : diskgroup string contains disks from an incompatible version of ASM
  • ora-12426 : invalid audit option
  • ora-19730 : can not convert offline plugged-in datafile string
  • ora-25122 : Only LOCAL bitmap indexes are permitted on partitioned tables
  • ora-31399 : Cannot contact LDAP server string at port number
  • ora-38307 : object not in RECYCLE BIN
  • ora-19870 : error reading backup piece string
  • ora-09953 : scggc: unexpected return of a lock convert
  • ora-25259 : cannot specify protocol for agent
  • ora-30647 : error retrieving access parameters for external table string.string
  • ora-00340 : IO error processing online log string of thread string
  • ora-23460 : missing value for column string in resolution method "string" for "string"."string"."string"
  • ora-31530 : could not find published column string for CDC subscriber view string.string
  • ora-28577 : argument string of external procedure string has unsupported datatype string
  • ora-40104 : invalid training data for model build
  • ora-13633 : The task string was interrupted and needs to be resumed.
  • ora-12472 : policy string is being used
  • ora-08274 : Out of memory for environment variable
  • ora-06304 : IPA: Message receive error
  • ora-24439 : success with PLSQL compilation warning
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • 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.