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

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

what is the differnce between process and thread ?

Name three advisory statistics you can collect.

How would you determine what sessions are connected and what resources they are waiting for?

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

When creating a user, what permissions must you grant to allow them to connect to the database?

how can you create a user-defined lock?

what do you understand by fine-grained auditing?

Give two methods you could use to determine what DDL changes have been made.

What are the steps you will take, if you are tasked with securing an SQL Server?

When a user process fails, what background process cleans up after it?

For more DB Administration Interview Questions Click Here