SQL Language (MOSC)

MOSC Banner

Materialized view and fast refresh mode behaviour

edited Jul 1, 2016 5:40PM in SQL Language (MOSC) 8 commentsAnswered

Hello,

I'm working with two databases, an operational database and a reporting database.

I created materialized views in the reporting database; These materialized views are associated with master tables and materialized view logs in the operational database.

Here's an example of one materialized view creation instruction (storage clause removed):

create materialized view user1.table1

refresh fast with primary key

as select * from user1.table1@myDBLink;

My problem is refresh didn't run since the mview creation date (june 2, master table was empty). Now, the master table contains records but no refresh process occurs (see request below)

select mview_name,refresh_mode,refresh_method,last_refresh_type,last_refresh_date from user_mviews;

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center