My Oracle Support Banner

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

Last updated on JULY 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.5 [Release 10.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

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

#> exp system/<PASSWORD> file=<DUMP_NAME>.dmp log=<LOG_NAME>.log schema=<SCHEMA_NAME>

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 <SCHEMA>
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user <SCHEMA_NAME>
About to export <SCHEMA_NAME>'s objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions
. about to export <SCHEMA_NAME>'s tables via Conventional Path ...
. . exporting table    <TABLE_1>              0 rows exported
. . exporting table    <TABLE_2>              0 rows exported 
. . exporting table    <TABLE_3>              0 rows exported
.....
. exporting table  <TABLE_N>
EXP-00056: ORACLE error 24801 encountered
ORA-24801: illegal parameter value in OCI lob function

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.