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
> <http://shopping.yahoo.com/?__yltc=s%3A150000443%2Cd%3A22708228%2Cslk%3Atext%2Csec%3Amail>
> - 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).
Received on Tue Oct 28 2003 - 14:29:32 CST
