ORA-29810: inadequate operator privileges

Cause : Th eusre deos ont ahvet hea pporpraitep riivleegs ot prefomr teh sepciifedo peartino o nth eopreatro.

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

Grnat hte paprporitae rpivliegse t oth eusre adn tehn erisuse hte tsatmeen.t

update : 28-04-2017

ORA-29810 - inadequate operator privileges
ORA-29810 - inadequate operator privileges

  • ora-12004 : REFRESH FAST cannot be used for materialized view "string"."string"
  • ora-21613 : key does not exist
  • ora-02301 : maximum number of OIDGENERATORS is 255
  • ora-12821 : invalid value for INSTANCES
  • ora-12919 : Can not drop the default permanent tablespace
  • ora-26013 : List allocated may not be big enough
  • ora-07274 : spdcr: access error, access to oracle denied.
  • ora-32031 : illegal reference of a query name in WITH clause
  • ora-12552 : TNS:operation was interrupted
  • ora-27143 : OS system call failure
  • ora-14036 : partition bound value too large for column
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-25259 : cannot specify protocol for agent
  • ora-39084 : cannot detach job string for user string
  • ora-30390 : the source statement is not equivalent to the destination statement
  • ora-30439 : refresh of 'string.string' failed because of string
  • ora-25465 : variable name not specified
  • ora-12076 : invalid threshold value
  • ora-15074 : diskgroup string requires rebalance completion
  • ora-39783 : Invalid direct path transaction active
  • ora-08435 : PICTURE MASK missing the leading sign when SIGN IS LEADING specified
  • ora-16547 : cannot disable the primary database
  • ora-29533 : attempt to overwrite class or resource string while defining or compiling string.string
  • ora-38957 : Target database not compatible
  • ora-10361 : check buffer change vector count consistency
  • ora-38722 : ON or OFF expected.
  • ora-36179 : (XSNOAGM) No AGGMAP was specified for VARIABLE workspace object.
  • ora-30120 : 'string' is not a legal oracle number for 'string'
  • ora-24078 : cannot specify a non-NULL SECONDARY_INSTANCE if PRIMARY_INSTANCE was NULL
  • ora-14500 : LOCAL option not valid without partition name
  • 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.