How can you Enforce Referential Integrity in snapshots ?
Answer / 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 |
How do we display rows from the table without duplicates?
How to declare a local variable?
What is parameterized cursor in oracle?
What is using clause and give example?
Display the records between two range?
Explain the use of grant option in exp command.
What are the differences between date and timestamp in oracle?
Can we call procedure inside function in oracle?
How do I know if oracle is installed on windows?
What are triggers in oracle?
what is integrity constrains?
Why does oracle 9i treat an empty string as null?