How to fix the Oracle error QSM-02020: container column not in SELECT list with NOT NULL constraint?

In this post, you’ll learn more about the Oracle ErrorQSM-02020: container column not in SELECT list with NOT NULL constraint with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-02020: container column not in SELECT list with NOT NULL constraint

Reason for the Error QSM-02020: container column not in SELECT list with NOT NULL constraint

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.

How to fix the Error QSM-02020: container column not in SELECT list with NOT NULL constraint ?

You can fix this error in Oracle by following the below steps

Disable or remove the NOT NULL constraint.