QSM-02052: subquery using a select list in mv
Answer / guest
Cause: The capability in question is not supported when the
materialized view uses a select list.
Action: Re-phrase the query to avoid the use of a select list.
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-25303: Buffered operation allowed only on the owner instance
ORA-25962: join index prevents multitable insert or merge
ORA-01079: ORACLE database was not properly created, operation aborted
QSM-01027: materialized view, string, is unusable
PLS-00381: type mismatch found at 'string' between column and variable in subquery or INSERT
PLS-00751: cannot find PACKAGE SYS_STUB_FOR_PURITY_ANALYSIS
ORA-24431: Statement does not exist in the cache
ORA-29386: plan or consumer group string is mandatory and cannot be deleted or modified
ORA-13785: missing target object for tuning task "string"
ORA-24042: no propagation schedule exists for QUEUE string and DESTINATION string
SQL*Loader-00507: unexpected EOF reading SDF or LOBFILE string for column string in table string
NID-00420: Change of database name and ID failed during validation - database is intact.