Archives of the TeradataForum
Message Posted: Fri, 29 Apr 2005 @ 17:00:34 GMT
No, that is not possible. What you can do is have two bteq jobs running, one on each system. Then, do a show table in server2, copy and paste it into the second bteq and run it. Then you can do a .export data file=????? on server2 and then your select * ...
Then, on the second bteq, do a .import data file=????? and insert the rows into the new table.
Besides, you wouldn't want to creat the new table from a "select *" anyway. You would lose all the characteristics of the old table (constrains, secondary indices, etc) and if not explicitly specified, the PI would be a NUPI on the first column. Instead you would want to do the following:
CREATE TABLE new_table AS old_table WITH DATA;
Hope this helps,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|