Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 28 Mar 2002 @ 12:57:30 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Any info on Insufficient Memory for Plastic Steps?
From:   Sid Gudes

Hi All,

I'm getting a Teradata error 3712, "Insufficient memory for Plastic Steps for this request", when I issue a certain SQL transaction. Anyone run into this before and have any ideas on what to do about it?

The documentation discusses whether it is a "simple" request or not, and I'm not clear on what "simple" means. The transaction in question is roughly:

about 75 updates
about 3 deletes
about 5 inserts

The Deletes and Updates use pretty simple Where clauses, 3 items and'ed together, no joins, no correlated suqueries, nothing fancy, and the Updates are updating about 3 columns each. Is that "simple" in the context of this message? If not, how do I simplify this?


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