Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What happens when a summary folder is refreshed?

April 26, 2017FOLDER happens refreshed summary

0

Posted

What happens when a summary folder is refreshed?

1 Answer

0

Posted

When a summary folder is refreshed (when running against Oracle 8.1.7 Enterprise Edition databases or later), the database server’s own refresh mechanism is used (this can be an incremental refresh) depending on your refresh settings. Whenever a summary folder is refreshed, the following actions are performed by Discoverer: The summary folder is marked as unavailable. The materialized view or summary table associated with summary folder is reconciled against its EUL metadata and if necessary the definition is updated. All existing summary data that is about to be refreshed is deleted. The summary data is regenerated and inserted into the corresponding materialized views or summary tables. The summary folder is marked as available.