materialized_views
This is an old revision of the document!
Table of Contents
Materialized_views
Create a view log for the master table
This is required for fast refresh
0@@
List all materialized view logs
1@@
Create a simple materialized view
2@@
where<br /> Fast = update changes only<br /> Complete = wipe and repopulate the mview<br /> Force = fast if possible, complete if not.<br /> <br />
Show all materialized views and their refresh times
3@@
Show materialized view tables and masters
4@@
Show refresh jobs in dba_jobs
5@@
Force a refresh
Fast - uses the changes in the view log on the source side.
6@@
Complete - truncates or deletes the data (depending on other options) and rebuilds the view from scratch (remember to gather view stats afterwards).
7@@
Force - tries a fast. If this does not work, a complete will be done.
8@@
Rebuild a broken View
Sometimes the materialised views stop working. If the original table was modified for example (maybe index was changed or a column removed), the view will fail.
- On PROD
9@@
- On QA
10@@
Remember to refresh the view stats!
11@@
materialized_views.1544130326.txt.gz · Last modified: 2018/12/06 21:05 by 91.177.234.129