Oracle-L: Re: ** materialized view fast not working

From: A Joshi <ajoshi977_at_yahoo.com>
Date: Tue, 28 Oct 2003 12:54:34 -0800
Message-ID: <F001.005D4D58.20031028125434@fatcity.com>

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 <Michael.Spalinger_at_Sun.COM> 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: Michael.Spalinger_at_Sun.COM

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: ListGuru_at_fatcity.com (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
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: A Joshi
  INET: ajoshi977_at_yahoo.com

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: ListGuru_at_fatcity.com (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).

Received on Tue Oct 28 2003 - 14:54:34 CST