ORA-14551: cannot perform a DML operation inside a query

Cause : MD Lporetaoi nileki snre,tu dpta,ed lete eros lece-tof-rpuadetc naon tebp reofmrdei sndi e auqre yrou dnrea P MD Llsva.e

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

nEusert ah tht efoefdnni gMD Lporetaoi nsin top reofmrdeo rsu enaa tunomouo srtnaastcoi notp reofmrt ehD LMo eparitnow tiih nht euqre yroP MD Llsva.e

update : 21-08-2017

ORA-14551 - cannot perform a DML operation inside a query
ORA-14551 - cannot perform a DML operation inside a query

  • ora-26082 : load of overlapping segments on table string.string is not allowed
  • ora-08446 : syntax error in SYNCHRONIZED clause in mask options
  • ora-29388 : plan/consumer_group string is part of more than one top-plan
  • ora-24172 : rule set string.string has errors
  • ora-16756 : resource guard could not open standby database read-only
  • ora-40302 : invalid classname string in cost matrix specification
  • ora-16242 : Processing logfile (thread# string, sequence# string)
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-29866 : cannot create domain index on a column of index-organized table
  • ora-19740 : text is longer than string
  • ora-32505 : too many watchpoints
  • ora-15116 : invalid combination of ALTER DISKGROUP options
  • ora-30500 : database open triggers and server error triggers cannot have BEFORE type
  • ora-01486 : size of array element is too large
  • ora-14613 : Attempt to generate name from parent name string and template name string failed as the combine named would have been longer than allowed
  • ora-19914 : unable to encrypt backup
  • ora-19831 : incompatible string.string.string.string DBMS_BACKUP_RESTORE package: string.string.string.string required
  • ora-12321 : database (link name string) is not open and AUTO_MOUNTING=FALSE
  • ora-12997 : cannot drop primary key column from an index-organized table
  • ora-40203 : model string does not exist
  • ora-30657 : operation not supported on external organized table
  • ora-32154 : Anydata context not specified
  • ora-40102 : invalid input string for data mining operation string
  • ora-16783 : instance string not open for read and write access
  • ora-22326 : cannot change a type to FINAL if it has subtypes
  • ora-02062 : distributed recovery received DBID string, expected string
  • ora-30386 : invalid SQL statement for DECLARE_REWRITE_EQUIVALENCE
  • ora-25156 : old style outer join (+) cannot be used with ANSI joins
  • ora-02403 : plan table does not have correct format
  • ora-10561 : block type 'string', data object# string
  • 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.