Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Mar 2005 @ 20:55:58 GMT


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


Subj:   Question on COPY
 
From:   Venkata Makkena

If table does not exists, Is Copy process really create a table with CURRENTSTAMP and update data dictionary on Target system?

As per my investigation, NO

1. Copy job will not create a table with CURRENT TIMESTAMP on target system; however, if table does not exists, the job will copy DDL with table header info. from the archived file (source system) and then transfer the data.

That's why the createtimestamp of the archived table is same on both taget system and the source system where the table has been archived.

Appreciate your feedback.


Thanks

Venkat



     
  <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: 27 Dec 2016