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 : 26-05-2017

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

  • ora-38954 : Cross platform transport is not supported between source platform identifier string and target platform identifier string
  • ora-16259 : Switchover to logical standby requires a log archive destination
  • ora-12711 : this CREATE CONTROLFILE character set is not allowed
  • ora-13033 : Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object
  • ora-24233 : argument passed to DBMS_UTILITY.VALIDATE is not legal
  • ora-24434 : OCIStmtRelease called before OCIStmtPrepare2.
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-09366 : Windows 3.1 Two-Task driver unable to allocate shared memory
  • ora-39708 : component 'string' not a string component
  • ora-37000 : (NOTALIAS00) workspace object is not an ALIAS DIMENSION of workspace object.
  • ora-01214 : MAXLOGHISTORY may not exceed string
  • ora-31492 : could not set session parameters for LogMiner session
  • ora-12686 : Invalid command specified for a service
  • ora-09751 : pw_attachPorts: server call pws_attach failed.
  • ora-39064 : unable to write to the log file
  • ora-29294 : A data error occurred during compression or uncompression.
  • ora-13043 : failed to read metadata from the _SDOLAYER table
  • ora-02383 : illegal cost factor
  • ora-10382 : parallel query server interrupt (reset)
  • ora-24123 : feature string is not yet implemented
  • ora-32318 : cannot rename a materialized view
  • ora-34722 : (NLSCHARSET05) CAUTION: Character data loss in character set conversion from string to string
  • ora-30551 : The index depends on a package/type body which does not exist
  • ora-30448 : internal data of the advisor repository is inconsistent
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-27091 : unable to queue I/O
  • ora-00375 : unable to get default db_block_size
  • ora-22976 : incorrect number of arguments to MAKE_REF
  • ora-02163 : invalid value for FREELIST GROUPS
  • ora-01772 : Must specify a value for LEVEL
  • 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.