ORA-24807: LOB form mismatch

Cause : When copying or appending LOBs, both source and desctination LOB locators should have the same character set form.

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

Pass locators of the same character set form for copying or appending LOBs.

update : 24-04-2017
ORA-24807

ORA-24807 - LOB form mismatch
ORA-24807 - LOB form mismatch

  • ora-01651 : unable to extend save undo segment by string for tablespace string
  • ora-28176 : incorrect certificate version
  • ora-24811 : less data provided for writing than indicated
  • ora-02734 : osnftt: cannot reset shared memory permission
  • ora-16755 : failed to set initialization parameter
  • ora-32146 : Cannot perform operation on a null date
  • ora-22291 : Open LOBs exist at transaction commit time
  • ora-30973 : invalid Path Table option for XML Index
  • ora-02292 : integrity constraint (string.string) violated - child record found
  • ora-23410 : materialized view "string"."string" is already in a refresh group
  • ora-09340 : Specified ORACLE_SID is either invalid or too long
  • ora-06775 : TLI Driver: error reading break mode
  • ora-13215 : window object is out of range
  • ora-14517 : subpartition of index 'string.string' is in unusable state
  • ora-16754 : resource guard could not activate standby database
  • ora-00165 : migratable distributed autonomous transaction with remote operation is not allowed
  • ora-02252 : check constraint condition not properly ended
  • ora-26023 : index string.string partition string was made unusable due to:
  • ora-06706 : TLI Driver: service not found
  • ora-01183 : cannot mount database in SHARED mode
  • ora-37179 : expected at least one column for dimension string, got string
  • ora-09260 : sigpidu: error obtaining process id
  • ora-06123 : NETTCP: cannot set KEEPALIVE
  • ora-12628 : TNS:no event callbacks
  • ora-14150 : missing SUBPARTITION keyword
  • ora-03233 : unable to extend table string.string subpartition string by string in tablespace string
  • ora-14400 : inserted partition key does not map to any partition
  • ora-08104 : this index object string is being online built or rebuilt
  • ora-02714 : osnpwr: message send failure
  • ora-19687 : SPFILE not found in backup 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.