Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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-36776: (XSPGERRTEMPSYSTEM) Ran out of temporary storage while writing to a system temporary analytic workspace. Free some temporary storage immediately. You can do so, for example, by DETACHING an analytic workspace.

1 Answers  


NZE-28812: record operation failure

1 Answers  


ORA-02320: failure in creating storage table for nested table column string

1 Answers  


ORA-08412: error encountered in WMSGBSIZ, size for WMSGBLK is not big enough for warning message

1 Answers  


ORA-24123: feature string is not yet implemented

1 Answers  






TNS-00040: INTCTL: failed to initialize trace context- Continuing anyway

1 Answers  


LSX-00132: attribute "~1S" has invalid occurrences value "~2S"

1 Answers  


ORA-33020: (XSAGDNGL09) In AGGMAP workspace object, the MIN argument of number must be less than the MAX argument of number.

1 Answers  


ORA-30186: '' must be followed by four hexdecimal characters or another ''

1 Answers  


ORA-16412: ONDEMAND archival requires active SQL apply operation

1 Answers  


ORA-31697: aborting operation at process order number string

1 Answers  


SQL*Loader-00132: invalid argument for external table option

1 Answers  






Categories