export with consistent=y raise snapshot too old error.

Hi,
  It raises
EXP-00056: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 2 with name
"_SYSSMU2$" too small

  when I do an export with consistent=y option.   And I find below information in alert_orcl.log Wed Apr 20 07:50:01 2005
SELECT /*+NESTED_TABLE_GET_REFS+*/ "XXX"."TABLENAME".* FROM
"XXX"."TABLENAME"

ORA-01555 caused by SQL statement below (Query Duration=1140060307 sec, SCN: 0x0000.00442609):
  Maybe the rollback tablespace is too small(about 300M)?   Any suggestions will be very appreciated.

Thanks.

wy. Received on Wed Apr 20 2005 - 02:20:10 CDT