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 : 18-08-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-02248 : invalid option for ALTER SESSION
  • ora-28231 : no data passed to obfuscation toolkit
  • ora-06544 : PL/SQL: internal error, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-14015 : too many partition descriptions
  • ora-27033 : failed to obtain file size limit
  • ora-02402 : PLAN_TABLE not found
  • ora-29329 : Table not of type XMLType
  • ora-28029 : could not authorize remote server for user string
  • ora-34021 : (MSCGADD04) You must specify a partition when maintaining PARTITION TEMPLATE workspace object.
  • ora-00392 : log string of thread string is being cleared, operation not allowed
  • ora-19589 : %s is not a snapshot or backup control file
  • ora-10652 : Object has on-commit materialized views
  • ora-16095 : Dependent destination removal for inactivation
  • ora-01986 : OPTIMIZER_GOAL is obsolete
  • ora-13788 : invalid recommendation type
  • ora-22929 : invalid or missing directory name
  • ora-31025 : Invalid document element
  • ora-25443 : duplicate column value for table alias: string, column number: string
  • ora-02034 : speed bind not permitted
  • ora-02283 : cannot alter starting sequence number
  • ora-02338 : missing or invalid column constraint specification
  • ora-12582 : TNS:invalid operation
  • ora-30369 : maximum number of columns is 32
  • ora-02422 : missing or invalid schema element
  • ora-09914 : Unable to open the ORACLE password file.
  • ora-32309 : object mview type "string"."string" does not match the master table type
  • ora-07842 : sllfcl: SYS$CLOSE failure
  • ora-00481 : LMON process terminated with error
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-12229 : TNS:Interchange has no more free connections
  • 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.