Interested to Buy Any Domain ? << Click Here >> for more details...
QSM-02020: container column not in SELECT list with NOT NULL
constraint
- 1 Answers
- 3104 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 |
ORA-19206: Invalid value for query or REF CURSOR parameter
ORA-02270: no matching unique or primary key for this column-list
PLS-01908: : RETURNING INTO buffer too small
ORA-01673: data file string has not been identified
TNS-00147: Failed to start a pre-spawned pump.
ORA-07214: slgunm: uname error, unable to get system information.
RMAN-06190: PL/SQL package string.string version string in string database is not current
ORA-03292: Table to be truncated is part of a cluster
ORA-32037: unsupported use of LEVEL in membership condition
ORA-15062: ASM disk is globally closed
ORA-13860: Invalid service name
ORA-16218: This database is already preparing to switch over.
Oracle Errors 
