ORA-39171 ORA-01693 During Data Pump Export (Doc ID 460628.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 21-Jun-2012***

Symptoms

expdp system/password full=y dumpfile=full_exp:patch11i%.dmp filesize=16G parallel=8
logfile=full_exp:patch11i.log job_name=patch11i

ORA-39171: Job is experiencing a resumable wait.
ORA-01693: max # extents (505) reached in lob segment SYSTEM.SYS_LOB0000808705C00039$$
ORA-39171: Job is experiencing a resumable wait.
ORA-01693: max # extents (505) reached in lob segment SYSTEM.SYS_LOB0000808705C00039$$
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.CREATE_OBJECT_ROWS while calling FORALL
[TABLE]
ORA-30032: the suspended (resumable) statement has timed out
ORA-01693: max # extents (505) reached in lob segment SYSTEM.SYS_LOB0000808705C00039$$

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 116
ORA-06512: at "SYS.KUPW$WORKER", line 6248


During the process of running EXPDP.

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