My Oracle Support Banner

Data Pump Import Through Network_link Generates ORA-31600 For Partitions And Subpartitions (Doc ID 1308448.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 to 11.2.0.1 - Release: 11.2 to 11.2
Information in this document applies to any platform.

Symptoms


*** Data Pump jobs through network_link involving subpartitioned tables fail with:

Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 20.73 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-31693: Table data object "FA"."LMP_DAILY" failed to load/unload and is being skipped due to error:
ORA-31600: invalid input value NULL for parameter VALUE in function SET_TRANSFORM_PARAM

*** After setting the 31600 errorstack the generated trace file shows the following information:

----- Error Stack Dump -----
ORA-31600: invalid input value NULL for parameter VALUE in function SET_TRANSFORM_PARAM
----- Current SQL Statement for this session (sql_id=6f5y07har86p7) -----
BEGIN
SYS.KUPW$WORKER.MAIN('TST_IMPORT4', 'SYSTEM', 0);
END;
----- PL/SQL Stack -----
----- PL/SQL Call Stack -----
object line object
handle number name
0x2f3a105f0 105 package body SYS.DBMS_SYS_ERROR
0x2ffda44a8 8129 package body SYS.DBMS_METADATA_INT
0x2ffda44a8 9270 package body SYS.DBMS_METADATA_INT
0x2f3a88f40 4766 package body SYS.DBMS_METADATA
0x2f39fc628 2569 package body SYS.KUPD$DATA
0x2f39fc628 3177 package body SYS.KUPD$DATA
0x2f3a25900 14237 package body SYS.KUPW$WORKER
0x2f3a25900 3127 package body SYS.KUPW$WORKER
0x2f3a25900 8860 package body SYS.KUPW$WORKER
0x2f3a25900 1651 package body SYS.KUPW$WORKER
0x2f37ea4c8 2 anonymous block

----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
skdstdst ksedst1 ksedst dbkedDefDump ksedmp dbkdaKsdActDriver dbgdaExecuteAction
dbgdaRunAction dbgdRunActions dbgdProcessEventActions dbgdChkEventKgErr dbkdChkEventRdbmsEr
PGOSF32_ksfpec dbgePostErrorKGE dbkePostKGE_kgsf kgeade kgerev kserec3 kkxerse pevm_icd_call_commo
pfrinstr_ICAL pfrrun_no_tool pfrrun plsql_run peicnt kkxexe opiexe kpoal8 opiodr kpoodr
upirtrc kpurcsc kpuexec OCIStmtExecute kupprwp ksvrdp opirip opidrv sou2o opimai_real
ssthrdmain main libc_start_main


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

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

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