Re: Materialized View Needing to be Refreshed

Here's a cript that I used to use to monitor my snapshot refreshes.

On 1/19/07, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> wrote:
>
> All,
>
>
>
> I have a table with MV logs in a source database. Two other databases
> have created MV's based on this table. Is there some way to determine which
> database needs to refresh their MV so that all of the MV logs will be
> cleared?
>
>
> Thanks
>
>
> Tom
>
>
>
> ------------------------------
>
> This transmission may contain confidential, proprietary, or privileged
> information which is intended solely for use by the individual or entity to
> whom it is addressed. If you are not the intended recipient, you are
> hereby notified that any disclosure, dissemination, copying or distribution
> of this transmission or its attachments is strictly prohibited. In
> addition, unauthorized access to this transmission may violate federal or
> State law, including the Electronic Communications Privacy Act of 1985. If
> you have received this transmission in error, please notify the sender
> immediately by return e-mail and delete the transmission and its
> attachments.
>
>
>
>

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




text/plain attachment: qmlogs.sql