Impdp Takes Forever On Tables With Lobs (Doc ID 1590012.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 07-Apr-2015***

Symptoms

Data Pump Import is running very slow while loading the data in a table with a lob column. The table has the following structure:

SQL> desc auditlog
Name                                      Null?    Type
----------------------------------------- -------- ----------------------------
ID                                        NOT NULL RAW(8)
CREATEDATE                                         NUMBER(38)
CREATETIME                                         NUMBER(38)
LOGGEDOBJECTID                                     RAW(8)
CLASSID                                            NUMBER(38)
LOGINENTITYID                                      RAW(8)
AUDITTYPE                                          VARCHAR2(32)
APPLICATION                                        VARCHAR2(32)
OBJECTNAME                                         VARCHAR2(254)
OPERATION                                          VARCHAR2(32)
SIGNIFICANCELEVEL                                  NUMBER(38)
SERVERSITE                                         VARCHAR2(32)
CLIENTSITE                                         VARCHAR2(32)
DATA                                               CLOB
OBJECTNAMEORGID                                    RAW(8)

 
The DW trace file shows that the following statement is running :

 

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