Tag: SYS.RGROUP$ R

This post demonstrates how to create and maintain a materialized view refresh group in Oracle database.

• create a materialized view refresh group
• add a materialized view into materialized view refresh group
• remove materialized view from a refresh group
• change interval of materialized view refresh group
• manually refresh a materialized refresh group
• drop a materialized refresh group
• health check materialized view group
• Troubleshooting : materialized view refresh group not working, cannot add or remove materialized view into or from materialized view refresh group , materialized view not refreshed by materialized view refresh group