My Oracle Support Banner

ORA-39001, ORA-39071, ORA-06553 When Running IMPDP Using NETWORK_LINK (Doc ID 812039.1)

Last updated on MARCH 04, 2019

Applies to:

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


When trying to refresh a schema in the development database with data from the production database using IMPDP with the NETWORK_LINK command line option, the following errors are raised:

ORA-39001: invalid argument value
ORA-39071: Value for SCHEMAS is badly formed.
ORA-06553: PLS-103: Encountered the symbol ".1D" when expecting one of the following:

. ( * @ & = - + ; < / > at in is mod remainder not rem
<> or != or ~= >= <= <> and or like LIKE2_
LIKE4_ LIKEC_ between || multiset member SUBMULTISET_




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

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