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

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

Re: Materialized View Needing to be Refreshed

From: Thomas Day <tomdaytwo_at_gmail.com>
Date: Fri, 19 Jan 2007 11:27:29 -0500
Message-ID: <9f0e18730701190827u3b6498b2j1ecdf81a37432740@mail.gmail.com>


Here's a frangment of something, hope it helps -

select snapid, r.name snapname, '||

' nvl(r.snapshot_site, ''not registered'') snapsite, ' ||
' snaptime ' ||
'from sys.slog$ s, dba_registered_snapshots r ' ||
'where s.snapid=r.snapshot_id(+)


On 1/19/07, Mercadante, Thomas F (LABOR) < Thomas.Mercadante_at_labor.state.ny.us> 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?
>
>
> 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 - 10:27:29 CST

Original text of this message

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