Oracle Error ORA-55569: The UNDO_RETENTION parameter value should be atmost string, the _highthreshold_undoretention setting.

Oracle Error Message

ORA-55569: The UNDO_RETENTION parameter value should be atmost string, the _highthreshold_undoretention setting.

Reason for the Error

The UNDO_RETENTION parameter value was not less than or equal to the _highthreshold_undoretention parameter setting.

Solution

Reissue the SQL statement with a lower value for UNDO_RETENTION parameter or increase the value of _highthreshold_undoretention parameter.