Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Materialized View Needing to be Refreshed

Materialized View Needing to be Refreshed

From: Mercadante, Thomas F \(LABOR\) <Thomas.Mercadante_at_labor.state.ny.us>
Date: Fri, 19 Jan 2007 09:50:28 -0500
Message-ID: <ABB9D76E187C5146AB5683F5A07336FFE08A5C@EXCNYSM0A1AJ.nysemail.nyenet>


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 Received on Fri Jan 19 2007 - 08:50:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US