Last updated on NOVEMBER 18, 2013
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 to 22.214.171.124 [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
Million Knowledge Articles and hundreds of Community platforms