Increase temporary tablespace size in oracle

If you want to know the location of temporary tablespace:

SELECT tablespace_name, file_name, bytes
FROM dba_temp_files WHERE tablespace_name = 'TEMP';

If you want to delete the temporary tablespace:

ALTER DATABASE 
TEMPFILE 'C:\APP\BI\ORADATA\ORCL\TEMP01.DBF' 
DROP INCLUDING DATAFILES;


Recreate your tablespace with maxsize:

ALTER TABLESPACE temp ADD TEMPFILE
'C:\APP\BI\ORADATA\ORCL\TEMP01.DBF' SIZE 512m
AUTOEXTEND ON NEXT 250m MAXSIZE UNLIMITED;