Oracle Error Message
QSM-02142: COUNT(*) is not present in the select list
Reason for the Error
The materialized view query omits COUNT(*) from the select list.
Solution
Add COUNT(*) to the select list.
QSM-02142: COUNT(*) is not present in the select list
The materialized view query omits COUNT(*) from the select list.
Add COUNT(*) to the select list.