Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 30 Oct 2003 @ 15:48:57 GMT


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


Subj:   Restore of procs and views
 
From:   Kaul, Rohit

Hi All,

Lets say I have a table and I have procedures and views built on that table. In the process of backing up I backup all of them and while restoring I restore the views and the procs first and then the table.

Is it ok to do it this way? Will I encounter some problems because of this (e.g., will the views or procs become invalid).

Is the only solution in such a case restoring the table first and then all other objects dependent on it?

Any information will be appreciated.

Rgds

Rohit



     
  <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