 |
 |
Archives of the TeradataForum
Message Posted: Mon, 13 Feb 2006 @ 22:45:53 GMT
| Subj: | | Re: Dblink in Teradata |
| |
| From: | | Anomy Anom |
<-- Anonymously Posted: Monday, February 13, 2006 05:45 -->
| | However, if your prod and test environments are physically hosted on the same system (which is much more often the case with Teradata than
with Oracle) you could just use INSERT ... SELECT. | |
No unfortunately.They are on two separate machines. My test machine is on 4700 and prodn on 5400.
I have managed, after much effort, to write a shell script which will,for a given table, extract and generate the multiload script and load it
into test.
Many thanks all for the inputs.
Warm Regards
| |
