Re: Materialized View Needing to be Refreshed
- From: Hemant K Chitale <hkchital@xxxxxxxxxxxxxx>
- To: Thomas.Mercadante@xxxxxxxxxxxxxxxxx, <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 20 Jan 2007 00:27:52 +0800
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
