Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Nov 2003 @ 11:47:04 GMT


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


Subj:   Re: Restoring just DDL
 
From:   David Wellman

Ian,

I think that the arc "dictionary rows" option will achieve this. After the restore (on your target system) you will then possibly have to use the "rebuild tables" command so that the developers can reference the tables in their sql.

Building the definition from dbc.tables etc may not work (and at best will be 'tricky' !), not all of the definition components are held in dictionary tables (e.g. Datablocksize option). Obviously if you don't use those options then this won't affect you. You can't use the RequestText/Createtext columns as they don't contain the full definition either.


Cheers,

Dave



     
  <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