Data Pump Export (expdp) terminates due to ORA-6502 when using a large Table List
Last updated on NOVEMBER 28, 2016
Applies to:Oracle Server - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Information in this document applies to any platform.
- Data Pump Export (expdp) terminates due to ORA-06502 when a where table list (such as provided by parameter file) is very large.
Export: Release 184.108.40.206.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 220.127.116.11.0 -
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.
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';
*** 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 ------------------
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.
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