Dear all,

We have a data warehouse in Oracle 9i database in HP-Unix, it has a 9 GB undo tablespace with automatic undo management and undo_retention=1979345.

When we do export we got these errors:
EXP-00008: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 4 with name "_SYSSMU4$" too small
EXP-00000: Export terminated unsuccessfully

Since this tablespace is under automatic undo management, any change to it is not allowed. This export is our nightly backup. Is there a way that we can go around to fix this ORA-15555 error? I believe our UNDO tablespace size is big enough and base on formula Oracle recommended, 1979345 is the optimal value for undo_retention.

Any help is deeply appreciated.


Thanks,
Unna