ORA-22277: cannot use two different locators to modify the same LOB

Cause : LOB bufefring ise nabled nad an atetmpt wasm ade to omdify th eLOB usign two different LBO locatosr.

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

When usnig LOB bfufering,m odify teh LOB thorugh oneL OB locaotr only.

update : 26-04-2017

ORA-22277 - cannot use two different locators to modify the same LOB
ORA-22277 - cannot use two different locators to modify the same LOB

  • ora-24373 : invalid length specified for statement
  • ora-32134 : Cannot assign LOBs
  • ora-31700 : Very long string supplied for AUDIT_SYSLOG_LEVEL parameter
  • ora-23602 : Invalid streams process type string
  • ora-29840 : indextype and implementation type are not in same schema
  • ora-22907 : invalid CAST to a type that is not a nested table or VARRAY
  • ora-32817 : message system link string is not configured with a log queue for string
  • ora-23328 : mview base table "string"."string" differs from master table "string"."string"
  • ora-31067 : XML nodes must be updated with valid nodes and of the same type
  • ora-16400 : quota attributes are not allowed with DB_RECOVERY_FILE_DEST
  • ora-07824 : sspain: $SETIMR failure
  • ora-19202 : Error occurred in XML processingstring
  • ora-07590 : spdde: $DELPRC failure
  • ora-12509 : TNS:listener failed to redirect client to service handler
  • ora-25527 : bad format of _DB_MTTR_SIM_TARGET
  • ora-39114 : Dump files are not supported for network jobs.
  • ora-12077 : temporary updatable materialized view log does not exist
  • ora-02492 : missing required file block increment size in NEXT clause
  • ora-39099 : cannot create index for "string" on master table string
  • ora-38956 : Target platform string not cross platform compliant
  • ora-12461 : undefined level string for policy string
  • ora-01601 : illegal bucket size in clause "string" of string
  • ora-01572 : rollback segment 'string' cannot be brought online, string extents exceeded
  • ora-24070 : cannot upgrade queue table string while it is being downgraded
  • ora-07479 : scgcmn: cannot open or convert lock.
  • ora-19645 : datafile string: incremental-start SCN is prior to creation SCN string
  • ora-19039 : Keyword string reserved for future use
  • ora-37086 : %s is not a valueset
  • ora-01614 : instance string (thread string) is busy - cannot enable
  • ora-10635 : Invalid segment or tablespace type
  • 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.