Answer Posted / rashid ansari
materialized view is database object.it just like nomal
view but u can maniputale into mateialized view.when u
fatch data from remotly,materialized view provide fater
fatching data from remote database.when user manipulate on
actual table then simply refersh to materlized view
automatically update materlized view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
How to shutdown your 10g xe server?
How to list all indexes in your schema?
What do you understand by database schema and what does it hold?
What are the different oracle database objects?
What is memory advisor in Oracle?
How to get execution statistics reports on query statements?
What is a user account in oracle?
what is the difference between substr and instr function in oracle?
How index is implemented in oracle database?
What is columnar storage what is the advantage?
What is the difference between 10g OEM and 11g OEM?
How to rename a column in an existing table?
What is the string concatenation operator in oracle?
How to assign a tablespace to a users in oracle?
How to sort output in descending order in oracle?