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
candidate key is subset of super key but not vice-verse explain
State some uses of redo log files?
How to use "if" statements on multiple conditions?
what are steps for interface? where is exchange rate defined in which table?
How to upsert (update or insert into a table)?
What is the purpose of save points in oracle database?
What is blob datatype?
How to loop through a cursor variable?
How can we force the database to use the user specified rollback segment?
Give the different types of rollback segments.
What is program global area (pga) in oracle?
How to get a create statement for an existing table?
what is the scenario where you take the database to NoArchivelog mode?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How would you best determine why your MVIEW couldnt FAST REFRESH?