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



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

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

Post New Answer

More Oracle Errors Interview Questions

ORA-16188: LOG_ARCHIVE_CONFIG settings inconsistent with previously started instance

1 Answers  


ORA-26706: cannot downgrade capture process

1 Answers  


PLS-00904: insufficient privilege to access object string

1 Answers  


SQL*Loader-00553: file not found

1 Answers  


ORA-07502: scgcmn: $enq unexpected return

1 Answers  






ORA-00036: maximum number of recursive SQL levels (string) exceeded

1 Answers  


IMG-00821: area N queue clear failed

1 Answers  


ORA-13224: zero tolerance specified for layer in USER_SDO_GEOM_METADATA

1 Answers  


ORA-23427: deferred purge queue argument string out of range

1 Answers  


NNO-00630: setting request-processing delay to number seconds

1 Answers  


CLSR-01001: Unsupported open mode number is specified

1 Answers  


ORA-26079: file "string" is not part of table string.string

0 Answers   Cisco,


Categories