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-04014: descending sequences that CYCLE must specify MINVALUE
TNS-00294: Connection Manager: Security is enabled, you cannot STOP the Interchange
IMG-00732: specified inputChannels could not be found in input image
IMG-00911: free basic data structure failed
ORA-22979: cannot INSERT object view REF or user-defined REF
ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION
ORA-14173: illegal subpartition-extended table name syntax
ORA-31408: invalid value specified for begin_scn or end_scn
DRG-10313: logging has already been started
IMP-00032: SQL statement exceeded buffer length
ORA-36873: (XSTFDSC03) Column type must be specified explicitly.
ORA-10646: Too many recursive extensions during SYSTEM tablespace migration