Oracle Discoverer Administrator Administration Guide 10g (9.0.4) Part Number B10270-01 |
|
Use this dialog to refresh the currently selected summary folder. For Oracle 8.1.7 (or later) Enterprise Edition databases you can also specify an incremental refresh if available (for more information, see the Oracle9i Data Warehousing Guide for conditions).
For more information about refreshing summary folders, see:
"Why must you refresh summary data?"
"What happens when a summary folder is refreshed?"
Use this radio button to refresh the selected summary folder immediately. Refresh will begin after clicking OK.
This option is useful when you have smaller materialized views or summary tables, or when you need to refresh the summary folder right away, without relying on the scheduling capabilities of the database server. Discoverer Administrator displays a progress bar enabling you to monitor the refresh.
Use this radio button to enable the Date and Time fields where you can use the arrow buttons or type into the fields to select a later date and time when you want the refresh to occur.
This option submits a job to the queue using DBMS_JOB and immediately returns you to Discoverer Administrator (rather than waiting for the refresh to be complete) enabling you to continue working. This option is useful when you have larger materialized views or summary tables, which are best built during off-peak hours.
Select this check box to perform an incremental refresh, available against Oracle 8.1.7 (or later) Enterprise Edition databases only.
An incremental refresh is faster than a full refresh as it incrementally adds the new data that has been inserted into the tables.
During a summary folder refresh with Oracle Standard Edition databases a full table scan is carried out.
Clear this check box to refresh the summary using a full table scan.
|
Copyright © 1996, 2003 Oracle Corporation. All Rights Reserved. |
|