Oracle Error ORA-12028: materialized view type is not supported by master site string

Oracle Error Message

ORA-12028: materialized view type is not supported by master site string

Reason for the Error

Pre-Oracle8 master sites are not able to support primary key or subquery materialized views that are able to perform a fast refresh.

Solution

Create a ROWID materialized view or use a master table from an Oracle8 site.