QSM-02020: container column not in SELECT list with NOT NULL
constraint
- 1 Answers
- 2564 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-12727: invalid back reference in regular expression
PLS-00405: subquery not allowed in this context
EXP-00010: %s is not a valid username
LPX-00200: could not convert from encoding ~1s to ~2s
ORA-27083: waiting for async I/Os failed
RMAN-06481: WARNING: backup piece 'string' cannot be found on the storage medium
ORA-24014: invalid value string, RETENTION_TIME should be FOREVER or non-negative
ORA-13202: failed to create or insert into the SDO_INDEX_METADATA table
ORA-12611: TNS:operation is not portable
ORA-02143: invalid STORAGE option
ORA-03291: Invalid truncate option - missing STORAGE keyword
IMG-00901: VIR signature version mismatch
Oracle Errors 
