Oracle Distributed Processing Question:

How can you Enforce Referential Integrity in oracle snapshots?

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.

Read All 12 Distributed Processing Questions
Previous QuestionNext Question
Differentiate simple and complex, oracle snapshots?What is an oracle snapshot log?