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 does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What is a View ?
what is the difference between UNION AND UNIONALL
i have procedure p1.and also i declare the same procedure in a package. whice one is efficient package procedure or procedure?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
What happens to indexes if you drop a table?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is Oracle table?
What is oracle sid?
Explain alias?
what are the advantages of running a database in NO archive log mode?
What are the components of Physical database structure of Oracle Database?