DataPump Import (IMPDP) Seems To Hang On Processing Object Type SCHEMA_EXPORT/TABLE/TABLE_DATA
(Doc ID 789700.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 126.96.36.199 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 07-Oct-2014***
When using non-default NLS parameters for the DataPump process, the import is extremely slow and seems to hang.
The DataPump import log file shows the hang on the following:
Completed 1 PROCACT_SCHEMA objects in 0 seconds
Processing object type SCHEMA_EXPORT/DB_LINK
Completed 3 DB_LINK objects in 0 seconds
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
Completed 9 SEQUENCE objects in 1 seconds
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Completed 292 TABLE objects in 14 seconds
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA <== Here
Some NLS parameters that cause this behavior:
The above are just examples and other settings may also cause the problem. The issue does not reproduce if NLS parameters are not set.
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