Archives of the TeradataForum

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

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

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>>