What is the difference between a TEMPORARY tablespace and a PERMANENT tablespac

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

Question Posted / guest

Answers were Sorted based on User's Feedback

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?..

Answer / guest

Temporary Tablespace is in generally used for sorting
purpose while Permanent tablespace is used to sore
permanent objects

Regards
Abhinav Phadnis

Is This Answer Correct ?

15 Yes

0 No

What is the difference between a TEMPORARY tablespace and a PERMANENT tablespace?..

Answer / kranthi

Permanent tablespace is used to store permanent objects etc
temporary tablespace is used for sorting

Is This Answer Correct ?

0 Yes

0 No

More DB Administration Interview Questions

You have just compiled a PL/SQL package but got errors, how would you view the errors?

Why does Oracle not permit the use of PCTUSED with indexes?

What are the different ways of moving data or databases between servers and databases in SQL Server?

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

one datafile is lost in standy side how can you recover that??

Give the stages of instance startup to a usable state where normal users may access it.

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

How would you determine the time zone under which a database was operating?

How do you switch from an init.ora file to a spfile?

how can you process messages in order asynchronously?

For more DB Administration Interview Questions Click Here