|
| Name | Fast Manual Materialized View Refresh |
| Rating |  |
| Created On | 05-MAR-09 |
| Category | XM Extensions |
| Database Version | 10.2 |
| Description | Use: Right Click on the materialized view name shows the menu item "Fast Manual Refresh' and the action "Refresh Materialized View"
paste the following code into an .xml-file and add this as an action-type extension:
<items>
<folder type="MATERIALIZED VIEW">
<name>Fast Manual Refresh</name>
<item type="MATERIALIZED VIEW" reloadparent="true">
<title>Refresh Materialized View</title>
<sql>
<![CDATA[BEGIN DBMS_MVIEW.REFRESH('"#OBJECT_NAME#"','F'); END;]]>
</sql>
<help>This action refreshes the selected Materialized View.</help>
</item>
</folder>
</items>
|
|
|
|
|
| I had to remove the ,'F' parameter because it didn't like me doing a fast refresh on my materialised views. Providing both options would make this a 5 star. | 10-DEC-2009 12:29AM
|
|
|
|