Rollback segment too small

[mscim]

Hi, anyone that has encountered this problem and solved it, please share with me on how to solve it. Your help will be very much appreciated.
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 3 with name "RBS2" too small
EXP-00008: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 3 with name "RBS2" too small
EXP-00000: Export terminated unsuccessfully

Thanks in advance.

 

[sem]

Do you have a larger rollback segment? If so, you may DEDICATE it to your transaction by
SET TRANSACTION USE ROLLBACK SEGMENT <segment name>

If not - create it or enlarge existing. Regards, Dima

 

[mscim]

Thanks for responding. I'm one of those crazy enough to take on database administration with having proper training. Please bear with me. I do have existing rollback segments. How do I extend it?

 

[sem]

Try this for changing:
ALTER ROLLBACK SEGMENT <segment_name>
STORAGE (MAXEXTENTS UNLIMITED);

I'd suggest you to create 1 large segment for complex procedures and call it RB_BIG.

CREATE ROLLBACK SEGMENT RB_BIG
TBLESPACE <tablespace name>
STORAGE(
INITIAL 1M
NEXT 1M
MAXEXTENTS UNLIMITED);

Then you may use it by SET TRANSACTION. It will also be used automatically if being the only ONLINE rollback segment. Regards, Dima