ORA-29873: warning in the execution of ODCIINDEXDROP routine

Cause : A warign was rteurned rfom theO DCIIndxeDrop ruotine.

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

Check ot see i fthe rotuine ha sbeen cdoed corerctly Cehck theu ser deifned wanring lo gtablesf or gretaer detials.

update : 27-06-2017
ORA-29873

ORA-29873 - warning in the execution of ODCIINDEXDROP routine
ORA-29873 - warning in the execution of ODCIINDEXDROP routine

  • ora-23337 : priority or value not in priority group string
  • ora-09855 : removeCallback: bad message format.
  • ora-32142 : maximum number of iterations exceeded
  • ora-32771 : cannot add file to bigfile tablespace
  • ora-01165 : MAXDATAFILES may not exceed string
  • ora-12841 : Cannot alter the session parallel DML state within a transaction
  • ora-30960 : The entity is neither an XPATH nor a NAMESPACE.
  • ora-08437 : invalid picture type in picture mask
  • ora-13203 : failed to read USER_SDO_GEOM_METADATA view
  • ora-06314 : IPA: Event set up failure
  • ora-06775 : TLI Driver: error reading break mode
  • ora-29660 : Unable to find the class defined in the EXTERNAL NAME clause
  • ora-31444 : parameter error while acquiring lock on string
  • ora-12354 : secondary object being dropped
  • ora-25508 : database is not mounted
  • ora-19161 : XP0004 - XQuery type mismatch: invalid argument type 'string' for function 'string'
  • ora-02203 : INITIAL storage options not allowed
  • ora-00450 : background process 'string' did not start
  • ora-08308 : sllfop: Cannot open file
  • ora-37082 : Invalid percent
  • ora-00294 : invalid archivelog format specifier 'string'
  • ora-32617 : missing MEASURES keyword in MODEL clause
  • ora-03215 : File Size specified for resize is too small
  • ora-29882 : insufficient privileges to execute indextype
  • ora-30391 : the specified rewrite equivalence does not exist
  • ora-01568 : cannot set space quota on PUBLIC
  • ora-16803 : unable to query a database table or fixed view
  • ora-24811 : less data provided for writing than indicated
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-26523 : rpc termination error
  • 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.