Re: DBMS_REFRESH

Is first documented in the Oracle8 Replication Release 8.0 A58245-01 (mine is the 8.0.5) manual :-)

Best regards/Venlig hilsen

Peter Gram
Sæbyholmsvej 18 DK-2500 Valby

Cell: (+45) 5374 7107
Home: (+45) 3874 5696
Email: peter.m.gram_at_gmail.com
linkedin: dk.linkedin.com/in/petergram/
OakTable : oaktable.net/members <http://oaktable.net/members>

On Tue, 22 Oct 2019 at 17:17, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l