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-13622: The recommendation annotation string is invalid.

1 Answers  


RMAN-06189: current DBID number does not match target mounted database (number)

1 Answers  


ORA-31059: Cannot insert root XML document node if it already exists

1 Answers  


ORA-06250: NETNTT: cannot allocate send and receive buffers

1 Answers  


ORA-03249: Uniform size for auto segment space managed tablespace should have atleast string blocks

1 Answers  






ORA-29836: failed to validate referenced operators

1 Answers  


RMAN-06459: BACKUP <VALIDATE|DURATION> is not supported with PROXY

1 Answers  


ORA-12719: operation requires database is in RESTRICTED mode

2 Answers  


ORA-27500: inter-instance IPC error

1 Answers  


PCC-00075: ":" expected before indicator variable

1 Answers  


IMG-00842: image index allocation failed

1 Answers  


DRG-11809: Partial Content

1 Answers  


Categories