QSM-02067: no partition key or PMARKER or join dependent
expression in select list
Answer / guest
Cause: The capability in question is not supported when the
materialized view unless the select list (and group by list
if a GROUP BY clause is present) includes the partition key
or PMARKER function reference to the table in question or an
expression join dependent on the partitioning column of the
table in question.
Action: Add the partition key or a PMARKER function
reference or a join dependent expression to the select list
(and the GROUP BY clause, if present).
Please add more information about this Error
| Is This Answer Correct ? | 0 Yes | 0 No |
ORA-13911: Threshold not found
DRG-11613: URL store: connection refused to host specified by string
TNS-00116: Pump failed during initial bequeath
ORA-01209: data file is from before the last RESETLOGS
ORA-16140: standby online logs have not been recovered
IMP-00068: Could not find environment national character set
DRG-10301: timed out waiting for responses from servers
PCC-00019: Unable to obtain bind variables at line number in file string
QSM-02143: SUM(expr) without COUNT(expr)
ORA-22858: invalid alteration of datatype
ORA-25292: Cannot add buffer on the specified queue
ORA-16000: database open for read-only access