Oracle Error Message
QSM-02020: container column not in SELECT list with NOT NULL constraint
Reason for the Error
The capability in question is not supported when the materialized view’s container table has a column that does not correspond to an output expression in the select list, and that column has a NOT NULL constraint. This situation can result in problems during refresh since any new rows inserted into the materialized view will set that column to NULL.
Solution
Disable or remove the NOT NULL constraint.
