question

Anthony Osborn 2 avatar image
Anthony Osborn 2 asked

TEMPORARY/PERMANENT tablespace?

What's the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

tablespace
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Andrew Mobbs avatar image
Andrew Mobbs answered

TEMPORARY tablespaces store data that only persists for the duration of a session, often internal objects used by the database engine. Examples are global temporary tables, temporary storage for large sort operations and temporary storage for large hash joins. TEMPORARY tablespaces use TEMPFILES, which are sparsely allocated on the filesystem.

PERMANENT tablespaces are for all "normal" persistent objects; tables, indexes, stored procedures. They use DATAFILES for storage.

The Concepts manual is the best reference for this sort of information: http://download.oracle.com/docs/cd/E11882_01/server.112/e10713/logical.htm#i2006

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.