Database Administration (MOSC)

MOSC Banner

Discussions

impdp takes forever with lob column in table (seems like inline lob is disabled)

edited Aug 5, 2022 2:02PM in Database Administration (MOSC) 9 comments

Hi

Oracle 10.2.0.5.0 RAC

I am doing export/import for certain schema to another database.

Certain table is 72G in size when doing the export.

. . exported "ZZZZZZ"."BBBBBB"            72.52 GB 19014621 rows

Table DDL is like this:

CREATE TABLE ZZZZZZ.BBBBBB (
 ID   NUMBER(12)              NOT NULL,
 VASTUS NUMBER(12)              NOT NULL,
 XML   CLOB                 NOT NULL
)
LOB (XML) STORE AS (
 TABLESPACE AAAAAAAA
 ENABLE   STORAGE IN ROW
 CHUNK    8192
 RETENTION
 NOCACHE
 STORAGE  (
       INITIAL     64K
       NEXT       1M
       MINEXTENTS    1
       MAXEXTENTS    UNLIMITED
       PCTINCREASE   0
       BUFFER_POOL   DEFAULT
       ))
TABLESPACE AAAAAAAA
PCTFREE  10
INITRANS  1
MAXTRANS  255
STORAGE  (
      INITIAL     64K
      NEXT       1M
      MINEXTENTS    1
      MAXEXTENTS    UNLIMITED
      PCTINCREASE   0
      BUFFER_POOL   DEFAULT
      )
NOCACHE;

So lob storage is inline.

When I am doing the import, the table DDL is exactly the same.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center