Network_Link DataPump Import (IMPDP) Fails With ORA-06502: PL/SQL: numeric or value error: character string buffer too small (Doc ID 2253469.1)

Last updated on MAY 16, 2017

Applies to:

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

Symptoms

While running DataPump Import with network_link, the job fails with:

> impdp directory=stage logfile=6apr2017.log network_link=nhk statistics=none schemas=maximoread

Import: Release 12.1.0.2.0 - Production on Thu Apr 6 09:32:25 2017
Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved.

Username: / as sysdba

Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
Legacy Mode Active due to the following parameters:
Legacy Mode Parameter: "statistics=none" Location: Command Line, ignored.
Starting "SYS"."SYS_IMPORT_SCHEMA_03": /******** AS SYSDBA directory=stage logfile=6apr2017.log network_li nk=nhk schemas=maximoread
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"MAXIMOREAD" already exists
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.FETCH_XML_OBJECTS [PROCACT_SCHEMA:"MAXIMOREAD"]
ORA-06502: PL/SQL: numeric or value error: character string buffer too small

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 11259


From 10046 DW trace file the error is reported for:

 

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