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 11.2.0.1 to 11.2.0.2 [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.

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: "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 ------------------

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

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.