ORA-14553: cannot perform a lob write operation inside a query

Cause : A olb rwit eopreatoin acnnto b epefroremd nisied aq ueyr o ra DPMLs laev.

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

Enusret ha tth eofefndnig olb rwit eopreatoin si nto prefomredo r sue na atuonmoou strnasatcio ntop erofrmt heo peartino wtihi nth equrey ro PMDL lsav.e

update : 25-04-2017
ORA-14553

ORA-14553 - cannot perform a lob write operation inside a query
ORA-14553 - cannot perform a lob write operation inside a query

  • ora-24770 : cannot forget a prepared transaction
  • ora-10565 : Another test recovery session is active
  • ora-14274 : partitions being merged are not adjacent
  • ora-16803 : unable to query a database table or fixed view
  • ora-31194 : Resource string is already deleted
  • ora-31691 : The worker received message number string from the MCP, which is invalid.
  • ora-12635 : No authentication adapters available
  • ora-24058 : cannot downgrade QUEUE_TABLE that has propagation in a prepared state
  • ora-12020 : materialized view string is not registered
  • ora-38437 : The ADT "string" may not contain any user methods.
  • ora-30031 : the suspended (resumable) statement has been aborted
  • ora-28116 : insufficient privileges to do direct path access
  • ora-16068 : redo log file activation identifier mismatch
  • ora-00333 : redo log read error block string count string
  • ora-37140 : (XSCCOMP15) Cannot AGGREGATE partitioned variable workspace object using AGGMAP workspace object because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.
  • ora-09774 : osnmui: cannot send break message
  • ora-16506 : out of memory
  • ora-02086 : database (link) name is too long
  • ora-19018 : Invalid character in XML tag 'string'
  • ora-02315 : incorrect number of arguments for default constructor
  • ora-16503 : site ID allocation failure
  • ora-16661 : the standby database needs to be reinstated
  • ora-36960 : (XSFCAST27) The value of the string expression must be an odd number. You specified number.
  • ora-36664 : (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.
  • ora-19860 : piece validation cannot be performed more than once
  • ora-12045 : invalid ALTER MATERIALIZED VIEW LOG option
  • ora-13268 : error obtaining dimension from USER_SDO_GEOM_METADATA
  • ora-13779 : invalid load option
  • ora-19699 : cannot make copies with compression enabled
  • ora-38444 : statistics do not exist for the expression set
  • 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.