2202967 - Collecting statistics fail with ORA-01555: snapshot too old

In some cases the following error may occur if you are trying to collect optimizer statistics with BRConnect for a table containing a huge number of rows.

BR0881I Collecting statistics for table <Owner>.<Table> with method/sample E/P3 ...
BR0280I BRCONNECT thread 11 time stamp: 2013-07-14 00.06.28
BR0301E SQL error -1555 in thread 11 at location stats_tab_collect-66, SQL statement:
'EXECUTE stmt_1a'
'BEGIN DBMS_STATS.GATHER_TABLE_STATS (OWNNAME => '"<Owner>"', TABNAME => '"<Table>"', ESTIMATE_PERCENT => NULL, METHOD_OPT => 'FOR ALL COLUMNS SIZE 1', DEGREE => NULL, CASCADE => TRUE, NO_INVALIDATE => FALSE); END;'                                           
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1_1719298697$" too small 
ORA-06512: at "SYS.DBMS_STATS", line 23435
ORA-06512: at "SYS.DBMS_STATS", line 23486
ORA-06512: at line 1
BR0886E Collecting statistics failed for table <Owner>.<Table>

• as of Oracle 10.2
• as of BR*Tools 7.20/7.40

KBA , BC-DB-ORA , Oracle , Problem