My Oracle Support Banner

DataPump Data_only Import In Network Mode From 11g or 10g to 12c Fails With ORA-31600 (Doc ID 2311551.1)

Last updated on MARCH 26, 2019

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

NOTE: The document content below, the user information and data used represents fictitious data from the Oracle sample schema(s) or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

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=impdp.log NETWORK_LINK=<NETWORK_LINK_NAME> content=data_only TABLE_EXISTS_ACTION=TRUNCATE tables=TEST.TABLE1
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

 

Changes

 NONE

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.