My Oracle Support Banner

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

Last updated on MARCH 13, 2019

Applies to:

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


Export: Release - 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 -
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:
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: "TABLE_TYPE_TABLE_TYPE_TABLE_TYPE" <== 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 ------------------


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


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


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.