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

Last updated on JANUARY 13, 2014

Applies to:

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

Symptoms

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

 

SQL> desc SYSMAN.MGMT_NOTIFY_QTABLE

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;

COUNT(*)
----------
65

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