Space Allocation

General
Enthusiast

Space Allocation

Hi,

   Can any one explain how space will be allocated for PERM,SPOOL,TEMP space with example in teradata.

Thanks,

Sravanthi

1 REPLY
Enthusiast

Re: Space Allocation

some examples;

CREATE DATABASE abc

   FROM def

AS

   PERM = 123456789

   SPOOL = 123456789

   FALLBACK

   ACCOUNT= 'xyz'

   NO AFTER JOURNAL

   DUAL BEFORE JOURNAL

   DEFAULT JOURNAL TABLE = abc.journals;

CREATE USER user2 FROM user1

       AS PASSWORD=mmmmmmm

       PERM=123456789

       SPOOL=0 /*123456789 */

       TEMPORARY=0

       ACCOUNT=''

There are lots of parameters  to arrive at allocation. I suggest you read these two since they are related. I am also reading , they are huge :) 

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111...

http://www.info.teradata.com/HTMLPubs/DB_TTU_14_00/index.html#page/Database_Management/B035_1094_111...