How can you Enforce Referential Integrity in snapshots ?
Answer Posted / nishi
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are actual and formal parameters?
Explain an exception and its types?
What is instant client oracle?
How to open a cursor variable?
Explain how are indexes update?
What is control file used for?
What is the difference between view and materialized view in Oracle?
Why does oracle 9i treat an empty string as null?
How to return top 5 rows in oracle?
What is a read write transaction in oracle?
What do you mean by a deadlock?
Explain database link?
How i can handle exception in large code like 1000 line without distrubing the code or without exception handler sction?
What is a parameter file in oracle?
What happens in oracle commit?