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

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

  • ora-14135 : a LOB column cannot serve as a partitioning column
  • ora-31651 : communication error with master process - detaching job
  • ora-09213 : slgfn: error fabricating file name
  • ora-25013 : OLD and PARENT values cannot be identical
  • ora-00132 : syntax error or unresolved network name 'string'
  • ora-00024 : logins from more than one process not allowed in single-process mode
  • ora-16071 : dependency archived log file not found string
  • ora-02753 : osnfsmmap: cannot close shared memory file
  • ora-26511 : master table 'string.string' not found
  • ora-28611 : bitmap index is corrupted - see trace file for diagnostics
  • ora-14185 : incorrect physical attribute specified for this index partition
  • ora-26688 : missing key in LCR
  • ora-32022 : parameter value longer than string characters
  • ora-28154 : Proxy user may not act as client 'string'
  • ora-12685 : Native service required remotely but disabled locally
  • ora-29881 : failed to validate indextype
  • ora-33016 : (XSAGDNGL07) In AGGMAP workspace object, workspace object is not a valid operator or variable name.
  • ora-06268 : NETNTT: cannot read /etc/oratab
  • ora-24162 : name value pair list is full, cannot add another entry
  • ora-13865 : Module name must be specified
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-07492 : scgrcl: cannot close lock.
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-31448 : invalid value for change_source
  • ora-28011 : the account will expire soon; change your password now
  • ora-01026 : multiple buffers of size > 4000 in the bind list
  • ora-38504 : this operator not allowed with the configured attribute set
  • ora-07216 : slghst: gethostname error, unable to get name of current host.
  • ora-07655 : slsprom:$TRNLOG failure
  • ora-27414 : Invalid BY value 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.