Oracle Error Message
QSM-02032: no joins are present in the WHERE clause
Reason for the Error
The capability in question is not supported when the materialized view includes no join conditions in the WHERE clause.
Solution
Re-phrase the query to include a join.