Materialized view and fast refresh mode behaviour
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;