QSM-02067: no partition key or PMARKER or join dependent
expression in select list
- 1 Answers
- 3787 Views
- I also Faced
- E-Mail Answers
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-13200: internal error [string] in spatial indexing.
ORA-13288: point coordinate transformation error
ORA-13620: The task or object string is read-only and cannot be deleted or modified.
ORA-13904: The file has been dropped and recreated during the procedure call.
DRG-11728: phrase does not have any broader terms of this type
ORA-24084: DBLINK name in address field of agent string is not unique within the first 24 bytes
ORA-01497: illegal option for ANALYZE CLUSTER
ORA-25409: failover happened during the network operation,cannot continue
ORA-26018: Column string in table string does not exist
ORA-25010: Invalid nested table column name in nested table clause
PLS-00716: Attribute/method 'string' can occur only once in an ALTER TYPE statement
PLS-00201: identifier 'string' must be declared
Oracle Errors 
