InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comThu, 04 Dec 2008 01:53:56 GMT20http://www.teradata.com/teradataforum/Topic11788-10-1.aspxThey are the Load-Utilities and loading a table is done from external source, normally. :)If you want to copy one table's data to other table, you can use INSERT SELECT statement.Regards,AdeelWed, 11 Jun 2008 23:17:04 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11788-10-1.aspxHi thanks for your reply.how about multiload and tpump? that also loads from flat file to a table and not from table to table?Wed, 11 Jun 2008 09:46:26 GMTdixonhttp://www.teradata.com/teradataforum/Topic11788-10-1.aspxHello,FastLoad is the utility to load data from flat-files/data-files to empty tables. You can move data between two tables using BTEQ script.Regards,AdeelTue, 10 Jun 2008 05:37:25 GMTAdeel.Chaudhryhttp://www.teradata.com/teradataforum/Topic11788-10-1.aspxHi alli'm looking for a clarification on fastload utility. my doubt is that, is it possible to load an empty table from some other populated table?. if yes could you please give me a sample script.i tried the following script but its not working. its throwing an error at sql statement. error is "invalid column list". i tried here with different ways to get it done but didn't worked. logon demotdat/tpch;drop table err1;drop table err2;drop table test;CREATE TABLE test,no FALLBACK,no AFTER journal,no BEFORE journal( start_date date NOT NULL, end_date date NOT NULL, bus_date date);set record text;define startdate (char(8)), /*just for name sake i gave coz fload expecting this */ enddate (char(8)), busdate (char(8))file=c:\input3.txt; /*just for name sake i gave coz fload expecting this */begin loading tpch.testerrorfiles tpch.err1, tpch.err2insert into test(:startdate,:enddate,:busdate) sel start_date, end_date, bus_date from test_load;end loading; logoff;i saw so many scripts that loads from flat file to empty table but not between table to table. ThanksDixonTue, 10 Jun 2008 05:33:44 GMTdixon