Oracle database: temp file

Temp files are similar to permanent data files. They differ in the following points

• They don't store permanent objects such as tables
• Temp files are in NOLOGGING mode and therefore don't generate redo data.