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 : 24-05-2017
ORA-14551

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

  • ora-01999 : password file cannot be updated in SHARED mode
  • ora-30196 : reserved for future use
  • ora-13462 : invalid blocking specification
  • ora-19830 : error from target database: string
  • ora-12041 : cannot record ROWIDs for index-organized table "string"."string"
  • ora-28526 : invalid describe information returned to Heterogeneous Services
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-26752 : Unsupported LCR received for "string"."string"
  • ora-12464 : invalid characters in label component string
  • ora-01880 : the fractional seconds must be between 0 and 999999999
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-12441 : policy string already exists
  • ora-12415 : A column of another datatype exists on the specified table
  • ora-12814 : only one CACHE or NOCACHE clause may be specified
  • ora-02223 : invalid OPTIMAL storage option value
  • ora-25213 : message with specified RELATIVE_MSGID has been dequeued
  • ora-15077 : could not locate ASM instance serving a required diskgroup
  • ora-01523 : cannot rename data file to 'string' - file already part of database
  • ora-16600 : failover operation can only be submitted at target database
  • ora-32341 : The EXPLAIN_MVIEW facility failed to explain the materialized view "string"."string"
  • ora-27062 : could not find pending async I/Os
  • ora-26727 : Cannot alter queue_to_queue property of existing propagation.
  • ora-17622 : failed to deregister the memory with Oracle Disk Manager library
  • ora-00821 : Specified value of sga_target stringM is too small, needs to be at least stringM
  • ora-13199 : %s
  • ora-30354 : Query rewrite not allowed on SYS relations
  • ora-02490 : missing required file size in RESIZE clause
  • ora-24190 : length of payload exceeds string
  • ora-16570 : operation requires restart of database "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.