Diagnosing ORA-1691 Or ORA-1653 Errors In Alert Log That Cause Data Pump Jobs To Fail (Doc ID 791253.1)

Last updated on AUGUST 03, 2015

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]
Information in this document applies to any platform.
***Checked for relevance on 03-Aug-2015***

Symptoms

Data Pump export jobs are not completing and the System tablespace is growing to an unusually large size.
The alert log file shows messages such as:

Sat Mar 14 08:30:29 2009
DM00 started with pid=56, OS id=14077, job SYSTEM.SYS_EXPORT_FULL_23
Sat Mar 14 08:30:32 2009
DW01 started with pid=58, OS id=14093, wid=1, job SYSTEM.SYS_EXPORT_FULL_23
Sat Mar 14 08:40:15 2009
statement in resumable session 'SYSTEM.SYS_EXPORT_FULL_23.1' was suspended due to
ORA-01653: unable to extend table SYSTEM.SYS_EXPORT_FULL_23 by 128 in tablespace SYSTEM
......
Fri Mar 13 20:32:52 2009
statement in resumable session 'SYSTEM.SYS_EXPORT_FULL_23.1' was suspended due to
ORA-01691: unable to extend lob segment SYSTEM.SYS_LOB0000321373C00044$$ by 1024 in tablespace SYSTEM


The export log file shows errors like:

ORA-39171: Job is experiencing a resumable wait.
ORA-01653: unable to extend table SYSTEM.SYS_EXPORT_FULL_23 by 128 in tablespace SYSTEM
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.CREATE_TABLE_DATA_OBJECT_ROWS [INSERT INTO "SYSTEM"."SYS_EXPORT_FULL_23" (object_type_path, object_path_seqno, process_order, duplicate, object_type, object_schema, original_object_schema, object_name, object_long_name, original_object_name, object_tablespace, flags, partition_name, subpartition_name, unload_method, parallelization, size_estimate, property, trigflag, processing_state, processing_status, base_process_order, base_object_type, base_object_schema, base_object_name, domain_process_order, name, creation_level) VALUES(:1, :2, :3, :4, :5, :6, :7, :8, :9, :10, :11, :12, :13, :14, :15, :16, :17, :18, :19, :20, :21, :22, :23, :24, :25, :26, :27, :28)]
TABLE_DATA:"SYSADM"."PS_PO_AUTOSRC_AET"
ORA-30032: the suspended (resumable) statement has timed out
ORA-01653: unable to extend table SYSTEM.SYS_EXPORT_FULL_23 by 128 in tablespace SYSTEM
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 105
ORA-06512: at "SYS.KUPW$WORKER", line 7845

 

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