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
--
http://www.freelists.org/webpage/oracle-l
- References:
- Materialized View Needing to be Refreshed
- From: Mercadante, Thomas F \(LABOR\)
Other related posts:
- » Materialized View Needing to be Refreshed
- » Re: Materialized View Needing to be Refreshed
- » Re: Materialized View Needing to be Refreshed
- » Re: Materialized View Needing to be Refreshed
- » RE: Materialized View Needing to be Refreshed
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?
- Materialized View Needing to be Refreshed
- From: Mercadante, Thomas F \(LABOR\)