Re: materialized view

mike7411_at_gmail.com wrote:
> I just want to know if the view has what is currently in the table.
>
> The count could easily be the same even if the data isn't current.
>
> Ranko.Mosic_at_gmail.com wrote:

>> select count(*) from table on both nodes; if same they are in sync,
>> Frank van Bortel wrote:
>>> mike7411_at_gmail.com schreef:
>>>> Is there an easy way to tell if a materialized view is in sync?
>>>>
>>>> Thank you.
>>>>
>>> Define in sync...
>>> Until then: Probably not.
>>>
>>> --
>>> Regards,
>>> Frank van Bortel
>>>
>>> Top-posting is one way to shut me up...

Since all of you are top posting: YOYO!

You were asked nicely.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org