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 |
What is the difference between view and materialized view in Oracle?
how to delete all duplicate records from a table using subquery?
How to find the duplicate rows count from employees table in oracle?
What is the difference between 10g OEM and 11g OEM?
How to apply filtering criteria at group level in oracle?
write a query that displays every Friday in a year with date?
What is an oracle user role?
How to export your own schema?
In Oracle Applications We are Using Sub Ledger Accounting. When we Transfer the Data all modules (AP,AR,CE,FA) to SLA We done Some customizations? What are They??
What is a named program unit?
What is memory advisor in Oracle?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?