Oracle Exception 01652 "unable to extend temp segement" & fix

oracle_exception_01652.txt

Oracle Exception:
{"ORA-01652: unable to extend temp segment by 2048 in tablespace TS_TEMP"}

Fix:
SELECT file_name, tablespace_name, ROUND(bytes/1024000) MB
FROM dba_data_files
ORDER BY 1;

alter tablespace ts_temp add TEMPFILE  'C:\app\inloox_oracle\product\12.1.0\dbhome_2\database\TEMP04.dbf' size 2000M autoextend on;