The temporary tablespace can reach a huge size, sometimes because of a big batch operation.
You may want to reduce it to save some disk space. If so, this article will present you some ways to do it.
RESIZE option can be used for temporary datafile but it may not be very efficient sometimes. For example, a 2800MB temporary datafile which has only 21MB in use, a
RESIZE COMMAND to 2600MB may give you this kind of error:
(Read this article about RESIZE : shrink-datafiles-with-resize.html) In case of the Resize option is not enough efficient, see the alternative way below.
Drop and recreate method
Then you can recreate TEMP by repeating all theses steps and finally drop TEMP2DROP at the end.
Enjoyed this article? Please like it or share it.