DataPump Import (IMPDP) Hangs On TABLE_STATISTICS (Doc ID 463322.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 10.2.0.3 [Release 10.2]
Information in this document applies to any platform.
***Checked for relevance on 26-Aug-2013***

Symptoms

Import using DataPump can be very slow and/or hangs on TABLE_STATISTICS:

-- Export
#> expdp '/ as sysdba' SCHEMAS=(QUARTZ,ANCAP,DATAPORTAL) directory=EXP_DIR dumpfile=$DUMPFILE logfile=$LOGFILE

-- Import
#> impdp '/ as sysdba' DUMPFILE=TS4_Dump_20071016.dmp LOGFILE=imp_ancap.log SCHEMAS=ancap remap_schema=ancap:ancap1 remap_tablespace=ts_ancap001:ts_ancap002, is_ancap001:is_ancap002 DIRECTORY=EXP_DIR

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