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

Last updated on OCTOBER 19, 2011

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

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