Transportable Tablespace (TTS) Using Impdp Seems to Hang at TRANSPORTABLE_EXPORT/PLUGTS_BLK Phase (Doc ID 1560225.1)

Last updated on JULY 04, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

Datapump import (impdp) using the transportable tablespace option (using impdp  parameter 'transport_datafiles=') seem to be hung

Last line written to the impdp log is "Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK", e.g.

---- <sample impdp.log> ----
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Master table "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01" successfully loaded/unloaded
Starting "SYSTEM"."SYS_IMPORT_TRANSPORTABLE_01":  system/******** parfile=dp_ttsimp.par
Processing object type TRANSPORTABLE_EXPORT/PLUGTS_BLK
---- <end of impdp.log> ----


Tracing impdp workers (trace=480300), the last line written to the worker trace file (<SID>_dw00_<PID>.trc) is like "KUPW:18:05:16.145: 1: DBMS_METADATA.CONVERT called.", e.g.

---- <sample worker trace file> ----
...
KUPW:18:05:16.144: 1: DBMS_METADATA.SET_TRANSFORM_PARAM returned. l_valid : 1 - Loading TRANSPORTABLE with type NULL
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading DBA with type JOB
KUPW:18:05:16.144: 1: l_valid : 1 - Loading EXPORT with type NULL
KUPW:18:05:16.144: 1: l_valid : 1 - Loading PRETTY with type NULL
KUPW:18:05:16.144: 1: l_valid : 1 - Loading SQLTERMINATOR with type NULL
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading CONSTRAINTS with type TABLE
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading REF_CONSTRAINTS with type TABLE
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading OID with type TABLE
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading RESET_PARALLEL with type INDEX
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading OID with type TYPE
KUPW:18:05:16.144: 1: l_valid: -3 - Not Loading OID with type INC_TYPE
KUPW:18:05:16.145: 1: l_valid: -3 - Not Loading REVOKE_FROM with type ROLE
KUPW:18:05:16.145: 1:
KUPW:18:05:16.145: 1: In procedure BUILD_OBJECT_STRINGS
KUPW:18:05:16.145: 1: DBMS_METADATA.CONVERT called.
---- <end of sample worker trace file> ----

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