I got the following error when running reorg or unload 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 = ?'
According to the Oracle message, please contact a DBA and ask them 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'
You can find more information here:
This can also be caused by a large amount of records being deleted at one time. Updating the reorg_chunk_size to a lower number in the unload ini file may help. More info can be found here: https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#AWA/Admin/inifiles/admin_ini_utility_db_unload.htm?Highlight=reorg_chunk_size