Version 9.0.2
Part Number A90881-02
 Home |
 Solution Area |
 Contents |
 Index |
| Oracle9i Discoverer Administrator Administration Guide Version 9.0.2 Part Number A90881-02 |
|
Use this dialog to refresh the currently selected summary. For Oracle 8.1.7 databases (or later) you can also specify an incremental refresh if available (see Oracle 8i server documentation 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 immediately. Refresh will begin after clicking OK.
This option is useful when you have smaller 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.
Select this radio button to highlight 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 summary tables, which are best built during off-peak hours.
Select this check box if you want to perform an incremental refresh, available against Oracle 8.1.7 databases (and later) 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 refresh with Oracle 8.1.5 databases (or earlier) a full table scan is carried out.
Clear this check box to refresh the summary using a full table scan.
|
 Copyright © 2002 Oracle Corporation. All Rights Reserved. |
|
