Archives of the TeradataForum
Message Posted: Wed, 14 Jun 2006 @ 14:04:12 GMT
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).
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|