Oracle Distributed Processing Question:

How can you Enforce Referential Integrity in oracle snapshots?

Distributed Processing Interview Question
Distributed Processing Interview Question

Answer:

Time the references to occur when master tables are not in use.
Peform the reference the manually immdiately locking the master tables. We can join tables in snopshots by creating a complex snapshots that will based on the master tables.


Previous QuestionNext Question
Differentiate simple and complex, oracle snapshots?What is an oracle snapshot log?