Help needed for understanding of space default behavior and limitations or rules

Database
N/A

Help needed for understanding of space default behavior and limitations or rules

Existing Database

Database Name = A1

Perm Space    = 100 GB

Spool Space   = 100 GB

Temp Space    = 100 GB

CREATE DATABASE A11 FROM A1

AS PERMANENT  = 20 GB;

What will be default Spool and Temp space allocated to database A11 ?

CREATE DATABASE A12 FROM A1

AS PERMANENT  = 20 GB

  ,SPOOL      = 1000 GB;

Will it allow me to create Database A12, as spool is more than 100 GB? ( Spool Space of A1)

CREATE DATABASE A13 FROM A1

AS PERMANENT  = 20 GB

  ,TEMPORARY  = 1000 GB;

Will it allow me to create Database A13, as Temp is more than 100 GB ( Temp Space of A1)

2 REPLIES

Re: Help needed for understanding of space default behavior and limitations or rules

Q1- If you do not specify spool and temp space, it will inherit the spool and temp space of parent that is A1 so the spool and temp space for A11 will be:

Spool = 100 GB

Temp = 100 GB

Q2- This will return an error that A1 do not have enough spool space. 

Q3- This will again return an error that parent do not have enough temporary space.

You can assign 0 spool and 0 temp space while creation of a database. These spaces can be added laters. 

Khurram
N/A

Re: Help needed for understanding of space default behavior and limitations or rules

Thanks Khurram...