ORA-01555: rollback segment number 9 with name "_SYSSMU9$" too smal
Hello Everyone,
[B]When:[/B]
While exporting a 30GB table getting this error
Environment:
I have an UNDO segment of 10GB. Retention is 7200.
(1) Segment Details
SQL> select SEGMENT_NAME,TABLESPACE_NAME,SEGMENT_ID from DBA_ROLLBACK_SEGS;
SEGMENT_NAME TABLESPACE_NAME SEGMENT_ID
------------------------------ ------------------------------ ----------
SYSTEM SYSTEM 0
_SYSSMU1$ UNDOTBS 1
_SYSSMU2$ UNDOTBS 2
_SYSSMU3$ UNDOTBS 3
_SYSSMU4$ UNDOTBS 4
_SYSSMU5$ UNDOTBS 5
_SYSSMU6$ UNDOTBS 6
_SYSSMU7$ UNDOTBS 7
_SYSSMU8$ UNDOTBS 8
_SYSSMU9$ UNDOTBS 9
_SYSSMU10$ UNDOTBS 10
SEGMENT_NAME TABLESPACE_NAME SEGMENT_ID
------------------------------ ------------------------------ ----------
_SYSSMU11$ UNDOTBS 11
_SYSSMU12$ UNDOTBS 12
_SYSSMU13$ UNDOTBS 13
_SYSSMU14$ UNDOTBS 14
_SYSSMU15$ UNDOTBS 15
_SYSSMU16$ UNDOTBS 16
_SYSSMU17$ UNDOTBS 17
18 rows selected.
(2) USAGE
(2) SQL> select tablespace_name,sum(bytes/1024/1024) from dba_segments where tablespace_name='UNDOTBS' group by tablespace_name;
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 118.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 118.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 118.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 118.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 113.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 111.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 122.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 122.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 114.992188
SQL> /
TABLESPACE_NAME SUM(BYTES/1024/1024)
------------------------------ --------------------
UNDOTBS 114.992188
Question
Why I am getting such error even when my UNDO has enough space to handle the transactions? Anything I am missing here?