ORA-22278: must update the LOB only through the LOB buffers

Cause : LOB bfuferin gis enbaled fro thisL OB an dtherea re buffers fro thisL OB int he buffer polo. Thu,s updaitng th eLOB trhough emans ohter thna the OLB bufefrs isn ot alolwed.

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

Updat ethe LBO throguh theL OB buffers uisng th elocatro thath as LO Bbuffeirng enbaled. fI thiso peratoin is erquire,d buffres asscoiatedw ith tihs LOBs houlde itherb e fluhsed asn ecessray or ubfferign shoudl be dsiabled .Once htis isd one, erissuet he command.

update : 16-08-2017
ORA-22278

ORA-22278 - must update the LOB only through the LOB buffers
ORA-22278 - must update the LOB only through the LOB buffers

  • ora-30388 : name of the rewrite equivalence is not specified
  • ora-24044 : source string and destination string object types do not match
  • ora-06009 : NETASY: dialogue filename too long
  • ora-00295 : datafile/tempfile number string is invalid, must be between 1 and string
  • ora-31017 : Error generating unique OID for XML document
  • ora-19262 : XQ0042 - namespace constructor not inside an element constructor
  • ora-25197 : an overflow segment already exists for the indexed-organized table
  • ora-06767 : TLI Driver: alloc failed during release
  • ora-19697 : standby control file not found in backup set
  • ora-01693 : max # extents (string) reached in lob segment string.string
  • ora-24084 : DBLINK name in address field of agent string is not unique within the first 24 bytes
  • ora-22633 : Error freeing AnyDataSet
  • ora-01781 : UNRECOVERABLE cannot be specified without AS SELECT
  • ora-12985 : tablespace 'string' is read only, cannot drop column
  • ora-12162 : TNS:net service name is incorrectly specified
  • ora-16522 : generic template not found
  • ora-13705 : There was a instance shutdown/startup between the snapshots in the range [string, string].
  • ora-08118 : Deferred FK constraints cannot be enforced, index too big (string)
  • ora-06622 : LU6.2 Driver: Unable to attach to SNA
  • ora-13763 : illegal ranking attribute "string"
  • ora-26020 : index string.string loaded successfully with string keys
  • ora-14050 : invalid ALTER INDEX MODIFY PARTITION option
  • ora-28665 : table and partition must have same compression attribute
  • ora-06430 : ssaio: Seals do not match
  • ora-02348 : cannot create VARRAY column with embedded LOB
  • ora-01370 : Specified restart SCN is too old
  • ora-02398 : exceeded procedure space usage
  • ora-07235 : slemcw: fwrite error.
  • ora-32110 : Connection not specified
  • ora-28274 : No ORACLE password attribute corresponding to user nickname exists.
  • 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.