When the temporary tablespace is too large, it can be rebuilt by the following methods.

SQL> Create temporary tablespace Temp2tempfile'/opt/Oracle/Oradata/Conner/temp1.DBF' with a size of 200M autoextend off.

SQL> Changing the Default Temporary Tablespace temp2 of Database

SQL> deletes tablespace temperature;

Or SQL >；; Delete table space temp, including content and data file cascade constraints (completely delete data files, including temporary table spaces in the operating system).

Finally, delete temporary files on the operating system to free up space.