AE - Error while running Reorg job ORA-01555: snapshot too old

Document ID : KB000110900
Last Modified Date : 13/08/2018
Show Technical Document Details
Issue:
I got the following error when running reorg job as below:
20180810/142218.599 - U00029108 UCUDB: SQL_ERROR Database handles DB-HENV: 2361050 DB-HDBC: 23abe68 
20180810/142218.599 - U00003591 UCUDB - DB error info: OPC: 'OCIStmtExecute' Return code: 'ERROR' 
20180810/142218.599 - U00003592 UCUDB - Status: '' Native error: '1555' Msg: 'ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_2210851416$" too small' 
20180810/142222.600 - U00000006 DEADLOCK 
20180810/142222.600 - U00003594 UCUDB Ret: '6' opcode: 'EXEC' SQL Stmnt: 'UPDATE AH SET AH_DeleteFlag = 1 WHERE AH_Idnr = ?'

How can I fix it?
Resolution:
According to the Oracle message, please contact your DBA and ask him/her to increase the size of rollback segment 8 with name "_SYSSMU8_2210851416$".
'ORA-01555: snapshot too old: rollback segment number 8 with name "_SYSSMU8_2210851416$" too small'
Additional Information:
You can find more information here:
http://www.dba-oracle.com/t_ora_01555_snapshot_old.htm
https://docs.oracle.com/database/121/ADMQS/GUID-26945DEA-D1F9-42BA-8CB5-7BE4DB6EC14D.htm#ADMQS12051 
https://docs.oracle.com/cd/B19306_01/server.102/b14200/statements_6013.htm