Oracle Error QSM-02185: no partition key or PMARKER in select list

Oracle Error Message

QSM-02185: no partition key or PMARKER in select list

Reason for the Error

The capability in question is not supported when the materialized view unless the select list (and group by list if a GROUP BY clause is present) includes either the partition key of or a PMARKER function reference to the table in question.

Solution

Add the partition key or a PMARKER function reference to the select list (and the GROUP BY clause, if present).