Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Feb 2006 @ 13:19:29 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


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



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023