 |
 |
Archives of the TeradataForum
Message Posted: Fri, 10 Feb 2006 @ 13:19:29 GMT
| Subj: | | Re: Dblink in Teradata |
| |
| From: | | Victor Sokovin |
| | Could you please let me know if there is anything analogous to the Database link of Oracle in Teradata? My problem is that I need to test
the scripts that Ive coded and there is hardly any relevant data on test env. So I need to get some data from production to test. Is there a way
to do this (other from exporting and importing) ? | |
There is no Teradata counterpart for the DB link.
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.
Regards,
Victor
| |
