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-36883: (XSSRF02) The first parameter of an AW single row function cannot be NULL.
ORA-39070: Unable to open the log file.
ORA-03132: two-task default value overflow
ORA-12990: duplicate option specified
NNL-00875: Average update processing time: string
ORA-19576: datafile string not defined in control file
KUP-04076: file name cannot contain a path specification: string
ORA-00344: unable to re-create online log 'string'
TNS-04084: WARNING: Non-reloadable parameters have retained their values.
PROT-00006: The specified import file cannot be found
NID-00303: Datafile string - wrote new name
ORA-23441: object does not exist for refresh group template