Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 04 Apr 2003 @ 08:21:49 GMT


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


Subj:   Re: RI After a restore.
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, April 03, 2003 19:32 -->

If you restore everything all you have to do is run a revalidate step. Tables that have referential integrity constraints cannot be updated until the references are revalidated. This is also true if you restore either the referencing or the referenced tahle.

Example ARCMAIN Script to perform a revalidate of DBNAME.

LOGON tpdid/user,passwd;
REVALIDATE REFERENCES FOR
(Dbname),
RELEASE LOCK;
LOGOFF;



     
  <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