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 : 18-08-2017
ORA-29873

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

  • ora-16808 : unable to resolve the full path name
  • ora-31671 : Worker process string had an unhandled exception.
  • ora-24056 : internal inconsistency for QUEUE string and destination string
  • ora-29659 : SQLJ Object Type validation failed to get default connection
  • ora-28116 : insufficient privileges to do direct path access
  • ora-32613 : not a MODEL cell
  • ora-21601 : attribute is not an object
  • ora-15081 : failed to submit an I/O operation to a disk
  • ora-01522 : file 'string' to be renamed does not exist
  • ora-24023 : Internal error in DBMS_AQ_EXP_INTERNAL.string [string] [string]
  • ora-13228 : spatial index create failed due to invalid type
  • ora-26076 : cannot set or reset value after direct path structure is allocated
  • ora-15025 : could not open disk 'string'
  • ora-36814 : (XSTBLFUNC07) The datatype of the column used in the ROW2CELL clause of a LIMITMAP must be RAW(16).
  • ora-26742 : Maximum number of ignored transactions exceeded
  • ora-22320 : missing user version string
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-06035 : NETDNT: connect failed, insufficient resources
  • ora-01115 : IO error reading block from file string (block # string)
  • ora-03251 : Cannot issue this command on SYSTEM tablespace
  • ora-12422 : max policies exceeded
  • ora-25286 : Invalid number of elements in the message properties array
  • ora-10265 : Keep random system generated output out of error messages
  • ora-33456 : (ESDREAD08) Discarding compiled code for workspace object because number is a(n) string, which string did not expect to find in a compiled program.
  • ora-12994 : drop column option only allowed once in statement
  • ora-14128 : FOREIGN KEY constraint mismatch in ALTER TABLE EXCHANGE PARTITION
  • ora-38716 : Must supply an integer for the TYPE option.
  • ora-31053 : The value of the depth argument in the operator cannot be negative
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-23349 : cannot generate replication support for functions
  • 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.