Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 22 Feb 2013 @ 14:46:01 GMT


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


Subj:   Re: Explain Plan-- Partitioned table
 
From:   Kenneth Hansen

To INS into Sel * from Teradata first does the sel * and if the total is less than the available spool space the transaction will fail.

Perhaps another user was using and therefore reducing the availability of spool for you?

If the table is large then I suggest you copy the table one partition at a time.


Ken



     
  <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: 23 Jun 2019