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 : 26-04-2017
ORA-14551

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

  • ora-14626 : values being added already exist in DEFAULT subpartition
  • ora-16801 : redo transport-related property is inconsistent with database setting
  • ora-19661 : datafile string could not be verified
  • ora-01978 : Missing sequence number
  • ora-02459 : Hashkey value must be a positive integer
  • ora-22912 : specified column or attribute is not a nested table type
  • ora-16238 : attempt to use version 9 log
  • ora-31426 : cannot modify active subscriptions
  • ora-09273 : szrfc: error verifying role name
  • ora-28601 : invalid [no]MINIMIZE option
  • ora-28555 : pass-through SQL: required parameter missing or NULL
  • ora-02204 : ALTER, INDEX and EXECUTE not allowed for views
  • ora-04012 : object is not a sequence
  • ora-31478 : could not detach LogMiner session after change set advance
  • ora-01698 : a clone database may only have SYSTEM rollback segment online
  • ora-26725 : cannot downgrade apply handlers
  • ora-12168 : TNS:Unable to contact LDAP Directory Server
  • ora-38955 : Source platform string not cross platform compliant
  • ora-02464 : Cluster definition can not be both HASH and INDEX
  • ora-39104 : cannot call this function from a SQL parallel query slave process
  • ora-02229 : invalid SIZE option value
  • ora-14191 : ALLOCATE STORAGE may not be specified for Composite Range partitioned object
  • ora-25140 : %s space policy cannot be specified for the string extent management
  • ora-19595 : archivelog string already included in backup conversation
  • ora-25473 : cannot store string in rule action context
  • ora-12686 : Invalid command specified for a service
  • ora-19029 : Cannot convert the given XMLType to the required type
  • ora-01220 : file based sort illegal before database is open
  • ora-29394 : session id string and serial# string do not exist
  • ora-13274 : operator invoked with non-compatible SRIDs
  • 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.