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 : 30-04-2017
ORA-29873

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

  • ora-06265 : NETNTT: break protocol error
  • ora-04935 : unable to get/convert SCN recovery lock
  • ora-36997 : (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
  • ora-38483 : invalid FUNCTION/PACKAGE/TYPE name: "string"
  • ora-23459 : flavor string must contain "string"
  • ora-27046 : file size is not a multiple of logical block size
  • ora-31093 : null or invalid value specified for parameter : string
  • ora-12597 : TNS:connect descriptor already in use
  • ora-26076 : cannot set or reset value after direct path structure is allocated
  • ora-23362 : invalid user
  • ora-30341 : dropped level has references
  • ora-25180 : PCTTHRESHOLD only valid for certain table organizations
  • ora-12419 : null binary label value
  • ora-32800 : internal error string
  • ora-12429 : label list range exceeded
  • ora-19525 : temporary file for the clone database must be renamed
  • ora-12855 : cannot run parallel or insert direct load in a loopback
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-00031 : session marked for kill
  • ora-26094 : stream format error: input column overflow
  • ora-06608 : LU6.2 Driver: Reset occurred in receive state
  • ora-28038 : disallow O2LOGON
  • ora-12830 : Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
  • ora-07415 : slpath: allocation of memory buffer failed.
  • ora-03244 : No free space found to place the control information
  • ora-27086 : unable to lock file - already in use
  • ora-02212 : duplicate PCTFREE option specification
  • ora-28171 : unsupported Kerberos version
  • ora-02171 : invalid value for MAXLOGHISTORY
  • ora-09200 : sfccf: error creating file
  • 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.