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?