ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

Cause : Failedt o succsesfullye xecutet he ODCIIndexExhcangePatrition orutine.

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

Check ot see i fthe rotuine ha sbeen cdoed corerctly.

update : 18-08-2017
ORA-29955

ORA-29955 - error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine
ORA-29955 - error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine

  • ora-00053 : maximum number of enqueues exceeded
  • ora-36212 : (XSAGOP06) In AGGMAP workspace object, you can only specify the MIN, MAX, FLOOR, and CEILING arguments while using the PROPORTIONAL operator, not string.
  • ora-16047 : DGID mismatch between destination setting and standby
  • ora-32582 : table function with left correlation to a table cannot also be left outer-joined to the table
  • ora-32507 : expecting string but found string
  • ora-21522 : attempted to use an invalid connection in OCI (object mode only)
  • ora-13037 : SRIDs do not match for the two geometries
  • ora-02736 : osnfpm: illegal default shared memory address
  • ora-27467 : invalid datatype for string value
  • ora-24181 : The type string does not exist
  • ora-30964 : The XML Index was not usable.
  • ora-16159 : Cannot change protected standby destination attributes
  • ora-02284 : duplicate INCREMENT BY specifications
  • ora-30178 : duplicate flag used in a format specification
  • ora-31040 : Property string: XML type (string) not compatible with internal memory type (string)
  • ora-10580 : Can not modify datafile header during test recovery
  • ora-29865 : indextype is invalid
  • ora-01207 : file is more recent than control file - old control file
  • ora-31657 : data filter name can not be defaulted
  • ora-02094 : replication option not installed
  • ora-01941 : SEQUENCE keyword expected
  • ora-25205 : the QUEUE string.string does not exist
  • ora-38719 : Invalid DUMP FLASHBACK object.
  • ora-32577 : username must be SYS or SYSTEM
  • ora-32846 : Messaging Gateway agent cannot be started; status is string
  • ora-10900 : extent manager fault insertion event #string
  • ora-12649 : Unknown encryption or data integrity algorithm
  • ora-32332 : cannot refresh materialized view "string"."string" as type evolution has occured
  • ora-13447 : GeoRaster metadata BRS error
  • ora-16016 : archived log for thread string sequence# string unavailable
  • 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.