[Oracle] ORA-1652 unable to extend temp segment

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

Solution :

This error occurs when there is insufficient space in the temporary tablespace or a process that has generated an abnormally high temporary space consumption.

We can consider updating the system statistics or we can just add more space to the tablespace.

Here's how :

to add a tempfile, here's how :