Re: DBMS_REFRESH
Date: Tue, 22 Oct 2019 15:27:54 +0000
Message-ID: <CWXP265MB17500BD5EFFED5CB72C6A3D9A5680_at_CWXP265MB1750.GBRP265.PROD.OUTLOOK.COM>
I think dbms_refresh has been around since at least 9.2 - I have a demo that involves a dblink called d920 !
Views: dba_rgroup for the groups, dba_rchild for the members of the groups
Regards
Jonathan Lewis
From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Mladen Gogala <gogala.mladen_at_gmail.com> Sent: 22 October 2019 16:16
To: oracle-l
Subject: DBMS_REFRESH
In Oracle 12c there is a new package called DBMS_REFRESH. It's very
convenient because it can fire off groups of materialized views at the
same time. The only problem is the group name: is there a table or view
which can show me which MV groups do I have created? I have a problem
with re-architected application which will use GG instead of
materialized views and I wanted to drop the schedule while leaving the
views themselves intact for a while. I had to search my old status
reports to find the name, which is very inconvenient. Does Oracle have
anything better?
--
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Oct 22 2019 - 17:27:54 CEST