Archives of the TeradataForum
Message Posted: Thu, 03 Jul 2003 @ 08:23:27 GMT
| Subj: | | Question about insert |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Thursday, July 03, 2003 12:09 -->
Dear all:
I got a situaction that i wnat to insert data from exists table to another table.
It take a long time (18 hours) when i run the insert sql statement in queryman.The sql statement like \'insert into
pmart.fact_sales select * from pdata.shopping_trans;\'. The source table :pmart.fact_sales has 6G table space.
Can someone help me to solve this problem?
| 
