Just wanted to know what is the use of temporary table space?
Last night I uploaded a 50 Meg file and this morning when I checked I noticed that my temp, system and dbname tablespaces are used upto 98%?
I understand that my dbname tablespace needs to be resized to something bigger but why have my system and temp datafiles reached to 98%? Shouldnt temp usually be empty when no processing is going on? And what do I do with the system datafile? Do I need to increase the size of that datafile(tablespace) too, since it is occupying 98% of the allocated space?