What Should I Do If Data Collection Fails and a Message SNAPSHOT TOO OLD Is Displayed?

If the collection fails or the error message "ORA-01555: snapshot too old" is displayed, check the UNDO parameters of the source Oracle database. Run the following command:

show parameter undo;

Command output:

NAME TYPE VALUE
undo_management string AUTO
undo_retention integer 28800

Contact the database administrator to increase the UNDO_RETENTION value.

ALTER SYSTEM SET UNDO_RETENTION =N;

Replace N with an appropriate value.