Diagnosing ORA-1691 Or ORA-1653 Errors In Alert Log That Cause Data Pump Jobs To Fail
(Doc ID 791253.1)
Last updated on JANUARY 30, 2022
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.1.0.7 [Release 10.2 to 11.1]Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
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
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"."<TABLE>"
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
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"."<TABLE>"
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
Changes
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |