My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

Applies to:

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


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


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

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