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-02049: timeout: distributed transaction waiting for lock
ORA-10637: The segment does not exist
ORA-31077: invalid attribute "string" specified
ORA-25500: database is not open
ORA-22333: cannot reset type "string"."string" due to invalid dependent types and tables
RMAN-04026: unable to open a temporary file: "string"
ORA-01764: new update value of join is not guaranteed to be unique
DRG-50907: score threshold string outside valid range 1 to 100
NZE-28754: object storage failure
ORA-31048: Unsaved resources cannot be updated
ORA-01534: rollback segment 'string' doesn't exist
ORA-09815: File name buffer overflow