Temporary tables use temporary segments in either a temporary tablespace or a permanent tablespace.

Question

Quizplus · Accepted Answer

Temporary tables use temporary segments in a temporary tablespace or a permanent tablespace. Temporary segments are allocated from temporary tablespaces, and the data in the temporary table is stored in the temporary segments. The temporary tablespace can be either locally managed or dictionary managed, and it is used by the database for temporary storage of data when processing large queries, sorts, and joins or creating indexes.

Temporary Tables Use Temporary Segments in Either a Temporary Tablespace