Oracle Error QSM-02142: COUNT(*) is not present in the select list

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.