Refresh Table
Go Up to Available object actions by DBMS
The Refresh Table dialog lets you reload materialized query tables defined with refresh options.
Platform Availability
To Reload a Materialized Query Table
- Initiate a Refresh Table action against one or more materialized query tables. For more information, see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings on the Refresh Materialized Query Table dialog:
| Pane | Description |
|---|---|
|
Action Options |
Select an Online Option of ALLOW NO ACCESS, ALLOW READ ACCESS or ALLOW WRITE ACCESS. Enable or disable Query Optimization. Select an INCREMENTAL or NOT INCREMENTAL Refresh Option. |
|
Preview |
Preview the DDL generated by the options you chose. For more information, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.
For procedures on restoring a damaged master database, consult the Commands Reference Manual.