Spool Space

Database
Enthusiast

Spool Space

What is the use of spool space for a database

1 REPLY
Senior Apprentice

Re: Spool Space

A database will never need/use spool space, but if a user is created as a child of this DB and the spool space is not specified, it will inherit the owner's spool space.

In fact every user/database has an assigned spool space (might be zero) even if all users got a PROFILE with spool and you never specified spool in create user/database. The Profile spool simply overwrites the individual spool.