EXPDP - ORA-39171 ORA-01691 (unable To Extend Lob Segment xxx By yyy In Tablespace SYSTEM) (Doc ID 1957683.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Standard Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Personal Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 12.1.0.2 [Release 10.1 to 12.1]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 12.1.0.6.0 [Release 10.1 to 12.1]
Information in this document applies to any platform.

Symptoms

1. You try to run an Export Data Pump or Import Data Pump job, but the following errors are reported:

$ expdp system/manager directory=my_dir dumpfile=expdp_f%U.dmp logfile=expdp_f.log reuse_dumpfiles=y full=y parallel=5

Export: Release 11.2.0.3.0 - Production on Mon Dec 29 11:03:57 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
FLASHBACK automatically enabled to preserve database integrity.
Starting "SYSTEM"."SYS_EXPORT_FULL_01":  system/******** directory=my_dir dumpfile=expdp_f%U.dmp logfile=expdp_f.log reuse_dumpfiles=y full=y parallel=5
Estimate in progress using BLOCKS method...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 4433. GB
Processing object type DATABASE_EXPORT/TABLESPACE
...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE
...
. . exported "SCOTT"."MY_TAB"                            1.025 GB 89207895 rows
ORA-39171: Job is experiencing a resumable wait.
ORA-01691: unable to extend lob segment SYSTEM.SYS_LOB0001522411C00045$$ by 1024 in tablespace SYSTEM
...

2. These errors can occur during a FULL database Export DataPump job, but also on other types (SCHEMA, TABLESPACE, TABLE) as well as on Import DataPump jobs.

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