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 : 27-06-2017

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

  • ora-25331 : cannot downgrade because there are commit-time queue tables
  • ora-31168 : Node localname and namespace values should be less than 64K
  • ora-12053 : this is not a valid nested materialized view
  • ora-13412 : invalid scale parameter
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-02076 : sequence not co-located with updated table or long column
  • ora-19270 : XP0050 - treat failed - expected string got string
  • ora-01113 : file string needs media recovery
  • ora-01983 : invalid auditing option for DEFAULT
  • ora-25137 : Data value out of range
  • ora-26520 : internal memory failure
  • ora-13381 : table:string not found in network:string
  • ora-13243 : specified operator is not supported for 3- or higher-dimensional R-tree
  • ora-13499 : %s
  • ora-19570 : file number string is outside valid range of 1 through string
  • ora-19605 : input filename must be specified
  • ora-39765 : stream must be reset before used in a column array conversion
  • ora-13149 : failed to generate next sequence number for spatial table string
  • ora-36682 : (XSDPART20) Partition name string appears twice.
  • ora-28155 : user 'string' specified as a proxy is actually a role
  • ora-24783 : Cannot switch non-migratable transactions
  • ora-01493 : invalid SAMPLE size specified
  • ora-19852 : error creating services for auxiliary instance string (error string)
  • ora-22281 : cannot perform operation with an updated locator
  • ora-25005 : cannot CREATE INSTEAD OF trigger on a read-only view
  • ora-01967 : invalid option for CREATE CONTROLFILE
  • ora-07453 : requested resource manager plan schema does not contain OTHER_GROUPS
  • ora-38444 : statistics do not exist for the expression set
  • ora-07579 : spini: $DCLEXH failure
  • ora-16518 : unable to allocate virtual instance id
  • 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.