QSM-02067: no partition key or PMARKER or join dependent expression in select l

QSM-02067: no partition key or PMARKER or join dependent
expression in select list

Question Posted / guest

1 Answers
3449 Views
I also Faced
E-Mail Answers

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

Post New Answer