EXPDP - ORA-39171 ORA-01691 (unable To Extend Lob Segment xxx By yyy In Tablespace SYSTEM)
Last updated on MAY 02, 2018
Applies to:Oracle Database - Personal Edition - Version 10.1.0.2 to 18.104.22.168 [Release 10.1 to 12.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 22.214.171.124 [Release 10.1 to 12.2]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 126.96.36.199.0 [Release 10.1 to 13.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 188.8.131.52 [Release 10.1 to 12.2]
Information in this document applies to any platform.
1. You try to run an Export Data Pump or Import Data Pump job, but the following errors are reported:
Export: Release 184.108.40.206.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 220.127.116.11.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.
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