DataPump Import (IMPDP) Seems To Hang On Processing Object Type SCHEMA_EXPORT/TABLE/TABLE_DATA
Last updated on OCTOBER 07, 2014
Applies to:Oracle Database - Enterprise Edition - Version 10.2.0.3 to 220.127.116.11 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms