Data Pump Export (expdp) terminates due to ORA-6502 when using a large Table List (Doc ID 1358039.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]
Information in this document applies to any platform.

Symptoms

Export: Release 11.2.0.2.0 - Production on Tue Jan 18 17:52:00 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 -
64bit Production
With the Partitioning option
ORA-06502: PL/SQL: numeric or value error

Example - Table list
--------------------
The parameter file covers more then 1300 table entries having following format:
tables=(
TABLE_1,
TABLE_2,
...
...
TABLE_n)
The issue occurs since RDBMS Release 11.2. No issue occurs with 11.1
The issue is also related to database character set which is AL32UTF8.

Diagnostic Analysis

When using a exception_dump dump it's clearly confirmed that the length (source value) of the table to be exported is larger then 30 characters which is the maximum length a table name can use.

Furthermore, analysis shows the affected table name (as confirmed by "Source Value") does not exist. It's more likely, that the resultant table name is a concatenation of multiple tables.

-- Enable event 6502 with EXCEPTION_DUMP option
alter system set events '6502 trace name exception_dump forever';

-- TARRS_dm00_3132.trc
*** 2011-06-14 14:47:11.230
--------- PL/SQL Exception Information ------------------
Suberror Message: character string buffer too small
Source Value: "ADDRESST_TYPE_PRODUT_TYPE_PRODUCT" <== Non-existing table
Source Length: 33 BYTE     <== table name larger then 30 characters.
Destination Length: 30 BYTE
----- PL/SQL Call Stack -----
object line object
handle number name
392a3fa98 16197 package body SYS.KUPM$MCP
392a3fa98 15588 package body SYS.KUPM$MCP
392a3fa98 4355 package body SYS.KUPM$MCP
392a3fa98 1394 package body SYS.KUPM$MCP
392a3fa98 1089 package body SYS.KUPM$MCP
392a3fa98 857 package body SYS.KUPM$MCP
392a50e88 2 anonymous block
--------- End of PL/SQL Exception Information ------------------

NOTE

Another symptom is described by <note 1466116.1> which is also confirmed to be caused by this <bug 11655916>. Unpublished BUG 10647999 addresses a similar issue. For more details have a look at <note 1354313.1>.

Changes

Export is using a parameter file uses are very large table list (more then 1300 tables). Character set is AL32UTF8.

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