See Note # 1031924.6You 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