ORA-01652 – ORA-01555
ORA-01652 UNABLE TO EXTEND TEMP SEGMENT
This error is caused because of Failing to allocate an extent of the required number of blocks for a temporary segment in the tablespace indicated.
ORA-01555: snapshot too old
ORA-01555 error occur due to a too-small undo_retention, even with a large undo tables.
Increase the undo_retention value to fix the issue.
ALTER SYSTEM SET UNDO_RETENTION = < seconds >;