EXPDP - ORA-39171 ORA-01691 (unable To Extend Lob Segment xxx By yyy In Tablespace SYSTEM)
(Doc ID 1957683.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database - Personal Edition - Version 10.1.0.2 to 22.214.171.124 [Release 10.1 to 12.2]
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 126.96.36.199 [Release 10.1 to 12.2]
Enterprise Manager for Oracle Database - Version 10.1.0.2 to 188.8.131.52.0 [Release 10.1 to 13.1]
Oracle Database - Standard Edition - Version 10.1.0.2 to 184.108.40.206 [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 220.127.116.11.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 18.104.22.168.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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!