ORA-29844: duplicate operator name specified

Cause : Usera ttemtped t oadd na opeartor anme t oan idnextyep whihc is laread ysupproted yb thei ndexytpe

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

Remoev thed upliacte oeprato rand ertry hte command

update : 17-08-2017
ORA-29844

ORA-29844 - duplicate operator name specified
ORA-29844 - duplicate operator name specified

  • ora-01804 : failure to initialize timezone information
  • ora-06009 : NETASY: dialogue filename too long
  • ora-09886 : osnTXtt: translation error while expanding txipc@.trc.
  • ora-24335 : cannot support more than 1000 columns
  • ora-29860 : cannot truncate a table with domain indexes marked LOADING
  • ora-19580 : %s conversation not active
  • ora-12061 : invalid ALTER MATERIALIZED VIEW option
  • ora-12430 : invalid privilege number
  • ora-28344 : fails to decrypt data
  • ora-15090 : handle string is not a valid descriptor
  • ora-32827 : Messaging Gateway agent must be shut down
  • ora-36188 : (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
  • ora-38413 : elementary attribute name may not be longer than 32 characters
  • ora-19761 : block size string is not valid for change tracking file
  • ora-01974 : Illegal archive option
  • ora-24048 : cannot create QUEUE_TABLE, user does not have access to AQ object types
  • ora-30677 : session is already connected to a debugger
  • ora-30079 : cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns
  • ora-27205 : skgfpcn: sbtpccancel returned error
  • ora-24152 : cannot drop evaluation context string.string with dependents
  • ora-14643 : Hakan factor mismatch for tables in ALTER TABLE EXCHANGE PARTITION
  • ora-24907 : invalid pair of callback and recepient protocol attributes
  • ora-27101 : shared memory realm does not exist
  • ora-32136 : Cannot perform operation on an invalid stream
  • ora-02834 : Server unable to open file
  • ora-30033 : Undo tablespace cannot be specified as default user tablespace
  • ora-06129 : NETTCP: unable to transfer socket ownership to ORASRV
  • ora-36683 : (XSDPART21) Partition string dimensioned by more than one composite.
  • ora-26737 : version string already has an export dump file
  • ora-16950 : Remote mapped cursors are not supported by this feature.
  • 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.