Discussions
impdp takes forever with lob column in table (seems like inline lob is disabled)
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.
0