ORA-12028: materialized view type is not supported by Master site.

Hi All,

I am facing problem in MView creation.

My base table and Mview log resides in remote server.

I am creating MView in my local database server. But getting an error ORA-12028: materialized view type is not supported by Master site.

Looking for solution for the mentioned problem.

For refrence i have given example as below:

 -- Materialized view log need to be create on base table schema (ie., source schema)

create materialized view log on rtab with rowid;

-- Matrialized view can be created in your destination schema

create materialized view GSM_RTEST
refresh fast with rowid
start with sysdate + 1/1440