QSM-02020: container column not in SELECT list with NOT NULL
constraint
- 1 Answers
- 2725 Views
- I also Faced
- E-Mail Answers
Answer / guest
Cause: 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.
Action: Disable or remove the NOT NULL constraint.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
LFI-00135: Unable to remove temporary file.
KUP-04104: zoned decimal field has bad values for string
ORA-29357: object string already exists
DRG-51030: wildcard query expansion resulted in too many terms
ORA-16552: An error occurred when generating the CLIENT OPERATION table.
ORA-24395: cannot reinitialize non-existent pool
LPX-00655: Invalid output comment '~S'.
RMAN-06107: WARNING: controlfile is not current for REPORT NEED BACKUP DAYS
ORA-01675: max_commit_propagation_delay inconsistent with other instances
ORA-01568: cannot set space quota on PUBLIC
ORA-32700: error occurred in DIAG Group Service
RMAN-00554: initialization of internal recovery manager package failed
Oracle Errors 
