Refresh Materialized View
Go Up to Available object actions by DBMS
This action lets you build and submit a REFRESH MATERIALIZED VIEW statement, to replace the contents of a materialized view.
Platform Availability
- Note: This action is only available against views created with the Is Materialized control selected. For more information, see Views Wizard (PostgreSQL).
To replace the contents of a materialized view
- Initiate an Refresh Materialized View action against a view. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the dialog:
| Step | Settings and tasks |
|---|---|
|
Action options |
If With No Data is selected, a WITH NO DATA clause is included in the generated DDL. No new data is generated and the materialized view will be in an unscannable state. |
|
Dependencies |
Review the referring and referred objects that will be automatically resolved when you execute this operation. For details, see Dependencies. |
|
Preview |
Displays the DDL that will execute the object action. For details, see Preview. |
- 3. Finally, use the Execute button to create the object.