Data Pump Import of Partitioned Tables Hangs at " Processing Object Type SCHEMA_EXPORT/TABLE/TABLE_DATA" Eventually Failing With ORA-01691 (Doc ID 1468121.1)

Last updated on NOVEMBER 18, 2013

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.3 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2013***

Symptoms

You are performing a Data Pump import of a partitioned table using the CONTENT=DATA_ONLY option. During the import you notice high utilization of the system tablespace on LOB segments.

The import starts to hang during the table data and then the following errors are seen:

Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment SYSTEM.SYS_LOB0000110534C00045$$ by 8192 in tablespace SYSTEM

 

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