Data Pump (or other Oracle process) Reports ORA-01628: Max # Extents (32765) For Rollback Segment _SYSSMUx$ (Doc ID 1434643.1)

Last updated on DECEMBER 06, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.1.0.6 and later
Information in this document applies to any platform.

Symptoms

A Data Pump Import job reports the following error:

ORA-01628: max # of extents (32765) reached for rollback segment _SYSSMU4$


On examination of dba_undo_extents  we see:

       SID    SERIAL# USERNAME        SEGMENT_NAME         Extent Count  USED_UBLK  USED_UREC PROGRAM
---------- ---------- --------------- -------------------- ------------ ---------- ---------- --------------------
       598       8623 SYSTEM          _SYSSMU4$                   32765    2340210  183312048 oracle@node1 (DW01)

Changes

A large Data Pump operation was started.

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