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

What's the benefit of "dbms_stats" over "analyze"?

How can you gather statistics on a table?

How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?

Datapump backup steps?

How will u copy the objects of one schema to another schema in datapump & export/import?

If CPU is very slow What can u do to speed up?

Query processing is slow(eg select query)how will u solve that

What is blocking and how would you troubleshoot it?

Give the reasoning behind using an index.

How do you resize a data file?

What is checkpoint?

Explain the difference between a hot backup and a cold backup and the benefits associated with each?

For more DB Administration Interview Questions Click Here