Impdp Takes Forever On Tables With Lobs

(Doc ID 1590012.1)

Last updated on FEBRUARY 12, 2018

Applies to:

Oracle Database - Enterprise Edition - Version and later
Information in this document applies to any platform.
***Checked for relevance on 12-Feb-2018***


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 :



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