0 - 2 of 2 tags for fix spool space issue

Please tell why this issue is happening that I am getting error as NO MORE SPOOL SPACE when I try to run the SQL from table (UDW2BASE.PROV_NPI_TXNMY) and when I create a volatile table of the same then it is running successfully.
I am unable to figure out the cause for “No more spool space”. 

Hi All,

i have a query which need to be tuned, currently the query is running out of spool. I tried to split the query, but not able to achive the expected result.

INSERT INTO TEST.Tmp_Table
(
Acct_id,