Question

ORA-1652: unable to extend temp segment by 128 in tablespace temp

Answer 1

We need to increase the size of the temp files(add up some space in temp tablespace). This error comes when temp tablespces's files(temp files) are not set to autoextended  or reached to its maximum limit.

alter tablespace TEMP add tempfile 'tempfile location and name' size 1024M;

alter database tempfile 'tempfile location and name' resize 2048M;