Oracle 11g resolves a problem with a temporary table space that is too large

Some databases are in use because some operations will lead to a temporary table space is too large, due to the working mechanism of temporary table space, the temporary table space will not be released after the job is completed.

This problem can be solved by rebuilding the temporal tablespace, but the operation is a bit cumbersome.

In the operation, it is found that the temporary tablespace can be freed through resize tempfile, and if there are multiple tempfile, the entire temporal tablespace can be freed by resize Tempfile 1, not just tempfile 1. You can then reach the storage resource that frees up the temporary tablespace by resize or by deleting other temporal tablespace data files.

Oracle 11g resolves a problem with a temporary table space that is too large