Database Administrator (DBA) Question:
How can you Enforce Referential Integrity in snapshots?

Answer:
Time the references to occur when master tables are not in use. Perform the reference the manually immediately locking the master tables. We can join tables in snapshots by creating a complex snapshots that will based on the master tables.
Previous Question | Next Question |
What is Two-Phase Commit? | What is a SQL * NET? |