DataPump Data_only Import In Network Mode From 11g or 10g to 12c Fails With ORA-31600

(Doc ID 2311551.1)

Last updated on OCTOBER 13, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Information in this document applies to any platform.

Symptoms

Running a DataPump import, using a network_link, from 12cR1 to 10gR2, fails with:

Starting "SYS"."SYS_IMPORT_TABLE_09": "/******** AS SYSDBA"
directory=DATA_PUMP_DIR logfile=imp_S21SBX_S21_APPS_subset_08192014104326.log
NETWORK_LINK=S21WSE_10G content=data_only TABLE_EXISTS_ACTION=TRUNCATE tables=S21_APPS.RPR_RCV_STS
Estimate in progress using BLOCKS method...
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CONFIGURE_METADATA_UNLOAD [ESTIMATE_PHASE]
ORA-31600: invalid input value IN ('VIEWS_AS_TABLES/TABLE_DATA') for parameter VALUE in function SET_FILTER
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-6512: at "SYS.DBMS_METADATA", line 3301
ORA-6512: at "SYS.DBMS_SYS_ERROR", line 95
@ ORA-6512: at "SYS.KUPW$WORKER", line 11259
----- PL/SQL Call Stack -----
object line object
handle number name
@ 0xb465a1b08 27116 package body SYS.KUPW$WORKER
@ 0xb465a1b08 11286 package body SYS.KUPW$WORKER
@ 0xb465a1b08 9060 package body SYS.KUPW$WORKER
@ 0xb465a1b08 17199 package body SYS.KUPW$WORKER
@ 0xb465a1b08 5235 package body SYS.KUPW$WORKER
@ 0xb465a1b08 12091 package body SYS.KUPW$WORKER
@ 0xb465a1b08 2081 package body SYS.KUPW$WORKER
@ 0xb5f8806a8 2 anonymous block KUPC$QUEUE_INT.SEND

 

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