Data Pump Import of Partitioned Tables Hangs at " Processing Object Type SCHEMA_EXPORT/TABLE/TABLE_DATA" Eventually Failing With ORA-01691
Last updated on NOVEMBER 18, 2013
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124 to 126.96.36.199 [Release 11.2]
Information in this document applies to any platform.
***Checked for relevance on 18-Nov-2013***
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:
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment SYSTEM.SYS_LOB0000110534C00045$$ by 8192 in tablespace SYSTEM
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