Archives of the TeradataForum

Message Posted: Wed, 27 Oct 2010 @ 09:38:03 GMT

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

Use this way it will work

     create volatile table testvolatile
     as (select * from database.table
     )
     with data
     on commit preserve rows
     ;

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