Re: DBMS_REFRESH

FYI: It also includes a minor security flaw in 19c.

https://oracle-base.com/articles/19c/dbms_job-jobs-converted-to-dbms_scheduler-jobs-19c#security

I have a bug open for this.

Cheers

Tim...

On Tue, Oct 22, 2019 at 5:07 PM Peter Gram <peter.m.gram_at_gmail.com> wrote:

> 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