Oracle Error Message
QSM-02187: materialized view on external table
Reason for the Error
The capability in question is not supported when the materialized view references an external table.
Solution
Re-phrase the query to avoid the use of the external tables.