Difference between Perm / Spool / Temporary Space

Database
RMM
N/A

Difference between Perm / Spool / Temporary Space

Hi ,

Please can anyone give me the exact difference between the below three spaces :-

1)Perm Space
2)Spool Space
3)Temporary Space

and also which is compulsorily required to create a Database / User .?

You quick help in the regard is highly apprecaited.

Cheers,

Rishikesh Mittal

2 REPLIES
N/A

Re: Difference between Perm / Spool / Temporary Space

The concept of perm/spool/temp is fully explained within the manuals, e.g.:
Database Administration
CHAPTER 3 Space Considerations

And
SQL Reference: Data Definition Statements
Chapter 2: SQL Data Definition Language Statement Syntax
CREATE DATABASE

will tell you that only perm is mandatory.

Dieter

Re: Difference between Perm / Spool / Temporary Space

Hi Rishi,

Please check this thread the explication is very good:

http://www.teradata.com/teradataForum/Topic132-9-1.aspx?Highlight=global+temporary