Spool space in insert statement

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Enthusiast

Spool space in insert statement

 

Hi,

 

If spool space for a user is reduced to 0 so it is possible for the user to run insert queries.

 

Thanks.

2 REPLIES
Teradata Employee

Re: Spool space in insert statement

INSERT VALUES normally does not require spool space, so would be possible even if the user's spool space limit was set to zero.

Highlighted
Enthusiast

Re: Spool space in insert statement

Thanks Fred for the details.

 

Is there any way of identifying which insert requires spool and which does not.