Has anyone experienced referential integrity (RI) problems while restoring
data from a dump? Like, if the dump doesn't restore the data in the right
order, then primary keys might not be in place before the foreign keys are
restored. I want to know this from people who have experience before I do
use RI!
Actually I did use RI in a database but had complications with it (I forget
exactly what it was, something like the order of PL/SQL procedures and RI
triggers firing caused some problems) but removed them all and just tried
implementing all the checks I wanted in my PL/SQL triggers myself.
--
-------- Robert B. Easter reaster@comptechnews.com ---------
- CompTechNews Message Board http://www.comptechnews.com/ -
- CompTechServ Tech Services http://www.comptechserv.com/ -
---------- http://www.comptechnews.com/~reaster/ ------------