Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 13 Oct 2010 @ 09:25:31 GMT


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


Subj:   ARC/RESTORE: - Copy database with No data.
 
From:   Ravi.Singh

Hi,

I have to copy some tables from a Test-box to Dev environment WITHOUT DATA. One way to do this is to execute SQL Show table for every table in Test, extract the DDL and create the same table in Dev. But there are more than 1000 tables to be copied in several databases, this approach would not work.

I want to know if there is any option like NO DATA in Restore utility which copies only table headers and pertaining dictionary rows (Not the data rows) to target System. If not, what could be the best possible way to do this.


Thanks,

Ravi Pratap
(Teradata certified DBA)



     
  <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