Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Apr 2006 @ 14:12:12 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Left-over spool table found: transaction aborted
 
From:   Choksi, Ketan

Check the SQL that is causing this error. May need to tune the SQL to reduce spool usage. Check the Explain of the sql's.

You can also use Global temp tables, which uses Temporary space rather then spool (which is used all users)


Thanks



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023