Error 1555(Snapshot too old) when running export

[Quoted] We are getting the following errors while running the export:

. . exporting table xxxx
EXP-00014: error on row 976303 of table xxxx

EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 10 with name "BIG_RESEG" too small
EXP-00000: Export terminated unsuccessfully.

This is on a 20-Gig table. The rollback tablespace is sized 250 Meg. The rollback segment is sized with initial extend 30 Meg, the next extend of 20 M and the optimal is 50 M.

Is this large enough? Is the solution really to make the rollback segment larger? Why is export using rollback segment anyway?

Is there any option in export like commit=y in import?

Please help. Thank you

Please send respond to me directly at c23866_at_is.nwa.com. Received on Tue Oct 28 1997 - 00:00:00 CET