SolutionIncrease the undo_retention parameter. The proper setting for this parameter can be determined by querying V$UNDOSTAT view once the database has been running for a while. Change the
UNDO_RETENTION parameter to at least equal the following query:
SQL> select max(maxquerylen) from v$undostat;
In our instance the value returned by above query was 14854.
undo_retention was correctly set as 36000 which is much above the 14854 requirement. The request completed successfully in 4 hours 15 minutes.