DataPump Import (IMPDP) Hangs When Using Parameters TRANSPORT_DATAFILES and REMAP_DATAFILE (Doc ID 762160.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.2 to 11.1.0.7 [Release 10.1 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 05-Aug-2015***

Symptoms

SCENARIO

#> impdp parfile=import.par

PARAMETER FILE (import.par)
---------------------------
REMAP_SCHEMA=user1:user2
REMAP_TABLESPACE=TEST1:TEST2
REMAP_DATAFILE="'/oracle/oradata/TEST/test1.dbf':'/oracle/oradata/TEST/test2.dbf'"
DIRECTORY=DATA_PUMP_DIR
LOGFILE='migrate_schema_test_imp.log'
DUMPFILE='migrate_schema_test_%U.dmp'
TRANSPORT_DATAFILES='/oracle/oradata/TEST/test1.dbf'

 

...
KUPW: 10:57:05.678: 1: in procedure ENABLE_TTS_IMPORT
KUPW: 10:57:05.680: 1: DBMS_PLUGTS.NEW_TABLESPACE with TEST1 called
KUPW: 10:57:05.790: 1: DBMS_PLUGTS.NEW_TABLESPACE returned
KUPW: 10:57:05.791: 1: DBMS_PLUGTS.NEWDATAFILE with
/oracle/oradata/TEST/test2.dbf called
KUPW: 10:57:05.791: 1: DBMS_PLUGTS.NEWDATAFILE returned
KUPW: 10:57:05.793: 1: DBMS_PLUGTS.PLUGGABLEUSER with USER1 called
KUPW: 10:57:05.793: 1: DBMS_PLUGTS.PLUGGABLEUSER returned
KUPW: 10:57:05.793: 1: DBMS_PLUGTS.MAPUSER old user is USER1 new user is USER2
called
KUPW: 10:57:05.793: 1: DBMS_PLUGTS.MAPUSER returned
*** 2009-01-19 11:00:37.202
*********START PLSQL RUNTIME DUMP************
***Got internal error Exception caught in pfrrun() while running PLSQL***
***Got ORA-39119 while running PLSQL***
PACKAGE BODY SYS.KUPW$WORKER:

 

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