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.2Information 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. |