Oracle Error ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

Oracle Error Message

ORA-01594: attempt to wrap into rollback segment (string) extent (string) which is being freed

Reason for the Error

Undo generated to free a rollback segment extent is attempting to write into the same extent due to small extents and/or too many extents to free

Solution

The rollback segment shrinking will be rollbacked by the system; increase the optimal size of the rollback segment.