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.


Increasing the temp tablespace size will resolve the issue.
1)check the previous available tempfiles location.

2)Check if there is sufficient space available in the mount point before increasing temp tablespace size.
3)Once the sufficient disk space is available increase the temp tablespace size.
alter tablespace temp add tempfile ‘/u01/app/oracle/oradata/oradb/temp3.dbf’ size 200m autoextend on next 100m maxsize 1g;

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 >;

  • September 27, 2018 | 23 views
  • Comments