Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 14 Jun 2006 @ 14:04:12 GMT

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

Subj:   Re: How to validate the invalid references created
From:   Victor Sokovin

  Does it mean that when we archive a database (which contains tables with foreign keys) and later restoring the database, the tables which has foreign keys are no longer reusable.????  

Not necessarily but very few shops actually use RI so this is more of a theoretical discussion. RI is difficult in Teradata, both on performance and DBA levels. One must have a very good reason to use it in production environments.

If you are interested in RI, you might need to consult the ARC manual. It does provide a good description of what should and should not be possible with RI. However, even the manual admits that bad cases *may* occur.

You would have a better chance of keeping RI intact if you archive and restore both the referencing and referenced tables. In case of problems you could then run REVALIDATE REFERENCES command, which might correct minor DBC problems without dropping the RI constraints (the coin's in the air, though).



  <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: 28 Jun 2020