ORA-29830: operator does not exist

Cause : Th eopreatro cuoldn otb e ofun.d

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

Veirfyt ha tth eopreatro eixst san dth eusre hsa EEXCUET pirvielgef ort hi sopreatro.

update : 24-07-2017
ORA-29830

ORA-29830 - operator does not exist
ORA-29830 - operator does not exist

  • ora-07401 : sptrap: cannot restore user exception handlers.
  • ora-21601 : attribute is not an object
  • ora-28042 : Server authentication failed
  • ora-13435 : GeoRaster metadata dimension inconsistent
  • ora-16129 : unsupported dml encountered
  • ora-01530 : a database already mounted by the instance
  • ora-12655 : Password check failed
  • ora-13871 : Invalid instance name
  • ora-28336 : cannot encrypt SYS owned objects
  • ora-02230 : invalid ALTER CLUSTER option
  • ora-00117 : PROTOCOL, ADDRESS or DESCRIPTION must be specified
  • ora-00130 : invalid listener address 'string'
  • ora-34357 : (MXDSS10) string is not an alias of analytic workspace string.
  • ora-36704 : (XSRELTBL06) workspace object should be dimensioned by workspace object.
  • ora-01255 : cannot shutdown - file string in recovery manager backup
  • ora-12404 : invalid privilege string: string
  • ora-17510 : Attempt to do i/o beyond file size
  • ora-01196 : file string is inconsistent due to a failed media recovery session
  • ora-16008 : indeterminate control file checkpoint
  • ora-29820 : the statistics type is not present
  • ora-27190 : skgfrd: sbtread2 returned error
  • ora-06504 : PL/SQL: Return types of Result Set variables or query do not match
  • ora-01123 : cannot start online backup; media recovery not enabled
  • ora-13425 : function not implemented
  • ora-02266 : unique/primary keys in table referenced by enabled foreign keys
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-07641 : smscre: Unable to use the system pagefile for the SGA
  • ora-02433 : cannot disable primary key - primary key not defined for table
  • ora-08233 : smsdes: cannot unmap SGA
  • ora-06960 : Failed to access log 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.