My Oracle Support Banner

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 MARCH 06, 2025

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 12.1.0.1 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database 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

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

> impdp directory=<directory_name> logfile=<log_name> network_link=<network_link> statistics=none schemas=<schema_name>

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: system/<password>

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 "SYSTEM"."SYS_IMPORT_SCHEMA_03": /******** <directory_name> logfile=<log_name> network_link=<network_link> schemas=<schema_name>
Estimate in progress using BLOCKS method...
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/USER
ORA-31684: Object type USER:"<username>" 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:"<schema_name>"]
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:

 

Changes

 

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.