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 JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 188.8.131.52 to 184.108.40.206 [Release 11.2]
Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document