Tempfile,”a tempfile is a special type of database file. Physically, it’s just like a regular data file, but it only holds temporary information. For example
a tempfile is used if you perform sorts on disk or if you’re using temporary tables. The space is then freed to the file either immediately after your operation is done or once you log out of the system.”