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

Temporary tablespace is needed when Oracle needs to perform sorting, and doing so is not possible in the memory, therefore it utilizes temporary tablespace. ORA-01652 means that oracle needs to allocate space from temp tablespace and it is not able to do so because temp tablespace is full. Alert log file would log error as follows.

Wed May 31 17:13:56 2017 ORA-1652: unable to extend temp segment by 128 in tablespace TEMP

Solution to this error is to add temp file to the temp tablespace or extend the existing temp files.