Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 04 Feb 2009 @ 14:13:27 GMT


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


Subj:   Archmain lose reference integrity
 
From:   Simard Rudel

Hi,

I am doing arcmain job to backup 3 tables with soft reference integrity.

I looking in DBC.All_RI_Children view and see row with InconsistenctFlag with N. That is good for me.

I delete those 3 tables and restore them in the same database.

I look again in DBC.All_RI_Children view no row found for those table. In my understanding, I expected find row with InconsistenctFlag with Y.

I look at the archmain command 'revalidate references for ...', but unfortunately, I did not get the reseult expected.

The soft reference integrity are gone.

Any information in my test appproach with soft RI backup-restore will be appreciate.


Thank you



     
  <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