My Oracle Support Banner

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

Last updated on MAY 18, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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/<PASSWORD> parfile=<PARFILE>
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> ----

Changes

 

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.