EXP-56 ORA-24801 During Export (Doc ID 874562.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 02-Jul-2015***

Symptoms

The traditional export utility (exp) raises the following errors:

#> exp system/password file=test.dmp log=test.log schema=vishwa

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses UTF8 character set (possible charset conversion)

About to export specified users ...
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user HDM_DBUSER
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user VISHWA
About to export VISHWA's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export VISHWA's tables via Conventional Path ...
. . exporting table    SALES              0 rows exported
. . exporting table    EMP                0 rows exported 
. . exporting table    LOC                0 rows exported
.....
. exporting table  TEST
EXP-00056: ORACLE error 24801 encountered
ORA-24801: illegal parameter value in OCI lob function

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms