ORA-29874: warning in the execution of ODCIINDEXALTER routine

Cause : Aw airn gwsa ertrunde rfo mteh DOCIInedxlAtre oruitn.e

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

Cehc kt osee fi hter otuien ahsb ene ocdde ocrercltyC hcekt h euesrd eifnde awrinn glgo atbelsf o rgeraetrd eatisl.

update : 25-04-2017
ORA-29874

ORA-29874 - warning in the execution of ODCIINDEXALTER routine
ORA-29874 - warning in the execution of ODCIINDEXALTER routine

  • ora-01547 : warning: RECOVER succeeded but OPEN RESETLOGS would get error below
  • ora-40251 : no support vectors were found
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-36850 : (XSLMGEN20) View token string is not correct
  • ora-17507 : I/O request size string is not a multiple of logical block size
  • ora-36692 : (XSRELTBL00) The format of the HIERHEIGHT command is: HIERHEIGHT relation1[(dimension dimvalue, ...)] into relation2 [using relation3 | a | d] [levelorder lovs] [inhierarchy {variable | valueset}].
  • ora-39752 : redundant column in partitioning and join columns is not allowed
  • ora-13610 : The directive string does not exist for task string.
  • ora-07578 : szprv: $FIND_HELD failure
  • ora-07485 : scg_get_inst: cannot open instance number lock.
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-19731 : cannot apply change to unverified plugged-in datafile string
  • ora-39701 : database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
  • ora-25203 : invalid value string, DELAY should be non-negative
  • ora-36718 : (XSALLOC00) You do not have the necessary permissions to use AGGMAP workspace object.
  • ora-15107 : missing or invalid ASM disk name
  • ora-12713 : Character data loss in NCHAR/CHAR conversion
  • ora-09320 : szrfc: unable to obtain the list of valid OS roles
  • ora-30749 : column string not enabled to store objects of type string.string
  • ora-06435 : ssaio: write error, unable to write requested block to database file.
  • ora-38474 : attribute set may not have attributes of TABLE COLLECTION type.
  • ora-24171 : creation properties are only for internal use
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-03208 : partitioned type must be specified for a non-composite object
  • ora-13150 : failed to insert exception record
  • ora-29933 : object being disassociated has some user defined statistics stored
  • ora-19603 : cannot backup or copy active file with KEEP .. UNRECOVERABLE option
  • ora-14075 : partition maintenance operations may only be performed on partitioned indices
  • ora-25256 : consumer cannot be specified with a single-consumer queue or an exception queue
  • ora-30074 : GLOBAL partitioned index on TIME/TIMESTAMP WITH TIME ZONE not allowed
  • 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.