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-30152: File does not exist
ORA-26685: cannot apply transactions from multiple sources
ORA-01661: tablespace 'string' is already temporary
NNL-01069: Log file name: string
ORA-19584: file string already in use
SQL*Loader-00916: Error checking path homogeneity
ORA-12987: cannot combine drop column with other operations
DRG-12431: configuration section string not found
ORA-14327: Some index [sub]partitions could not be rebuilt
ORA-39041: Metadata filter has no selectivity.
PCC-00025: Undeclared indicator variable "string" at line number in file string
ORA-26530: unable to build materialized view refresh control list