Hi friends
What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Satyapriya NayakPosted Dec 19, 2011, 11:41 PM
A temporary tablespace is used for temporary objects such as sort structures while permanent tablespaces are used to store those objects meant to be used as the true objects of the database.
Thanks
Pravin MorePosted Dec 19, 2011, 11:36 PM
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.
Thanks,
Pravin.