ORA-24813: cannot send or receive an unsupported LOB

Cause : An attempt was made to send a LOB across the network, but either the server does not support the LOB sent by the client, or the client does not support the LOB sent by the server. This error usually occurs when the client and server are running different versions of Oracle.

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

Use a version of the Oracle that supports the LOB on both the client and the server.

update : 23-06-2017
ORA-24813

ORA-24813 - cannot send or receive an unsupported LOB
ORA-24813 - cannot send or receive an unsupported LOB

  • ora-02045 : too many local sessions participating in global transaction
  • ora-01263 : Name given for file destination directory is invalid
  • ora-02165 : invalid option for CREATE DATABASE
  • ora-14102 : only one LOGGING or NOLOGGING clause may be specified
  • ora-29806 : specified binding does not exist
  • ora-12319 : database (link name string) is already open
  • ora-02065 : illegal option for ALTER SYSTEM
  • ora-39301 : schema "string" does not exist or is in use
  • ora-01983 : invalid auditing option for DEFAULT
  • ora-39305 : schema "string" does not exist
  • ora-00033 : current session has empty migration password
  • ora-12469 : no user levels found for user string and policy string
  • ora-10638 : Index status is invalid
  • ora-32775 : cannot change size attributes of read only tablespace string
  • ora-30368 : ATTRIBUTE cannot determine column in a different relation
  • ora-12561 : TNS:unknown error
  • ora-13185 : failed to generate initial HHCODE
  • ora-07508 : scgfal: $deq all unexpected return
  • ora-02030 : can only select from fixed tables/views
  • ora-09344 : spsig: error signalling thread
  • ora-08191 : Flashback Table operation is not supported on remote tables
  • ora-24791 : invalid transaction start flags
  • ora-30346 : hierarchy name must be unique within a dimension
  • ora-32147 : Environment not specified
  • ora-08499 : Warning: picture mask options 'string' ignored by UTL_PG
  • ora-26015 : Array column string in table string is not supported by direct path
  • ora-39071 : Value for string is badly formed.
  • ora-01095 : DML statement processed zero rows
  • ora-22980 : must specify a set of attributes for the WITH OBJECT OID clause
  • ora-30464 : no summaries exist
  • 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.