 |
 |
Archives of the TeradataForum
Message Posted: Wed, 14 Jun 2006 @ 14:04:12 GMT
| 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).
Regards,
Victor
| |
