Re: ** materialized view fast not working

[A Joshi]

Mike : Yes the user has select access and is able to do a select on the MLOG table and the original table. Thanks for your help.

Mike Spalinger <[EMAIL PROTECTED]> wrote:

Does the user have select access on the mlog?

A Joshi wrote:
> Hi,
> I have a table tableA owned by userA.
> If I create a materialized view in another schema/user fast and complete
> refresh set to refresh every 10 minutes then only complete refresh works
> and refreshes automatically every 10 minutes. However the fast refresh
> mv does not refresh automatically. It refreshes fine if the user
> executes DBMS_SNAPSHOT.REFRESH procedure.
>
> If I create a materialized view in the same user fast and complete
> refresh set to refresh every 10 minutes both work fine and refresh
> automatically every 10 minutes.
>
> Can some one help. Thank you
>
>
>
>
>
> ------------------------------------------------------------------------
> Do you Yahoo!! ?
> The New Yahoo! Shopping
>
> - with improved product search


--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mike Spalinger
INET: [EMAIL PROTECTED]

Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

---

Do you Yahoo!?
Exclusive Video Premiere - Britney Spears