Grantee names longer than 28 characters causes ORA-39127, ORA-06502 errors in EXPDP (Doc ID 1682053.1)

Last updated on JUNE 16, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

Errors in data pump export after upgrade to 11.2.0.4

ERROR
-----------------------
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/PROCOBJ
Processing object type DATABASE_EXPORT/SYSTEM_PROCOBJACT/POST_SYSTEM_ACTIONS/PROCACT_SYSTEM
ORA-39127: unexpected error from call to export_string :=SYS.DBMSZEXP_SYSPKGGRNT.SYSTEM_INFO_EXP(1,dynconnect,'11.02.00.00.00',newblock)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at "SYS.DBMSZEXP_SYSPKGGRNT", line 174
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 10096
Processing object type DATABASE_EXPORT/SCHEMA/PROCACT_SCHEMA
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE

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