My Oracle Support Banner

DataPump Export Receives ORA-31693 And ORA-6502 On Table With Data in ANYDATA Column (Doc ID 558595.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 13-Jan-2014***


During a DataPump export of a table which contains data in a column having datatype of ANYDATA results in following error:

. . .
. . exported "SYSMAN"."MGMT_JOB_SQL_PARAMS" 6.265 KB 2 rows
. . exported "SYSMAN"."MGMT_JOB_SUBST_PARAMS" 5.625 KB 2 rows
ORA-31693: Table data object "SYSMAN"."MGMT_NOTIFY_QTABLE" failed to load/unload and is being
skipped due to error:
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
. . exported "SYSMAN"."MGMT_POLICY_RULE" 47.14 KB 45 rows
. . exported "SYSMAN"."PARAM_VALUES_TAB" 9.328 KB 36 rows
. . .



Name                      Null?    Type
------------------------- -------- ----------------------------
Q_NAME                             VARCHAR2(30)
MSGID                     NOT NULL RAW(16)
CORRID                             VARCHAR2(128)
USER_PROP                           ANYDATA

SQL> select count(*) from SYSMAN.MGMT_NOTIFY_QTABLE where USER_PROP is not NULL;



To view full details, 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 a vibrant support community of peers and Oracle experts.