Re: Materialized View Needing to be Refreshed

See Note # 1031924.6
You should be able to "reverse-engineer" from there using SYS.SLOG$ SNAPID and SNAPTIME against
MLOG$_<basetable>

Hemant

At 10:50 PM Friday, Mercadante, Thomas F \(LABOR\) 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?

Hemant K Chitale
http://web.singnet.com.sg/~hkchital
and
http://hemantoracledba.blogspot.com

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