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

Last updated on DECEMBER 15, 2010

Applies to:

Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 10.2.0.5 - Release: 10.1 to 10.2
Information in this document applies to any platform.

Symptoms

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_

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