top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Oracle: What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?

+4 votes
769 views
Oracle: What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?
posted Apr 1, 2015 by Suchithra

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

+1 vote
 
Best answer

A temporary table space 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.

answer Apr 2, 2015 by Arun Gowda
0 votes

A temporary tablespace

It is used for temporary objects such as sort structures.

Permanent tablespaces

It is used to store those objects meant to be used as the true objects of the database.

temporary tablespaces are used for sorting operations

and

permanent tablespaces are tablespace that related to system
or sysaux datafile (system and sysaux are mandatory datafiles)

answer Apr 2, 2015 by Shivaranjini
...