Archives of the TeradataForum

Message Posted: Fri, 22 Nov 2002 @ 14:15:03 GMT

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

You could load a table from another table's data in two ways, without the use of any tools :

1. If you want to duplicate an existing table with all its data,or need a subset of a table or data from different tables - accompanied with the table creation : then use the

'CREATE TABLE AS {|}WITH DATA'

2. On the other hand if the table already exists then use INSERT SELECT clause.

The above is possible if the tables exists within the same database or across databases , but on the same box.Across boxes you could use the utilities like FastLoad,Bteq,FastExport.

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