Oracle Error ORA-32344: cannot create a secondary materialized view with synonym as base table

Oracle Error Message

ORA-32344: cannot create a secondary materialized view with synonym as base table

Reason for the Error

It is not supported to create a secondary materialized view with synonym in the FROM clause.

Solution

Removed the synonym(s) from the statement.