http://netvouz.com/MondoTofu/tag/view?feed=rss MondoTofu's bookmarks tagged "view" on Netvouz http://rwijk.blogspot.nl/2009/09/fast-refreshable-materialized-view_13.html Fast refreshable materialized view errors, part seven: a summary Oracle > DB 11g MondoTofu Sun, 07 Apr 2013 02:32:21 GMT http://www.bluegecko.net/oracle/how-to-max-out-your-fast-refresh-materialized-views/ DBMS_ADVISOR.TUNE_MVIEW, Oracle > DB 11g MondoTofu Thu, 24 Jul 2014 13:37:22 GMT http://en.wikipedia.org/wiki/Model%E2%80%93view%E2%80%93controller Model view controller Software Engineering MondoTofu Wed, 10 Oct 2012 16:07:16 GMT https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=1c8aacrmhq_386&_afrLoop=2886417712899739 Due to the restrictions on fast refresh, the original materialized view can only use fast refresh after inserts since there is no count(*) in the materialized view defining statement. Oracle > DB 11g MondoTofu Wed, 24 Sep 2014 20:07:05 GMT https://oracle-base.com/articles/misc/detect-and-correct-corruption Detect And Correct Corruption in Oracle Oracle > DB 11g MondoTofu Wed, 07 Jun 2017 21:13:17 GMT http://gavinsoorma.com/2011/02/using-tune_mview-and-explain_rewrite-to-enable-us-to-tune-mv-fast-refreshes-and-query-rewrites/ Use 11g packages in DBMS_MVIEW to see how the SQL query transformed or rewritten to use materialized view instead Oracle > Optimization MondoTofu Mon, 22 Sep 2014 13:55:04 GMT http://www.tebyan.net/index.aspx?PID=31159&LANGUAGE=3&PageSize=1&BOOKID=23870&PageIndex=167 Oracle > PL/SQL 11g MondoTofu Wed, 14 Jul 2010 15:59:20 GMT