QSM-02185: no partition key or PMARKER in select list



QSM-02185: no partition key or PMARKER 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 either the
partition key of or a PMARKER function reference to the
table in question.

Action: Add the partition key or a PMARKER function
reference 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

More Oracle Errors Interview Questions

ORA-07497: sdpri: cannot create trace file 'string'; errno = string.

0 Answers  


PCC-02391: Runtime context variable not of correct type

1 Answers  


ORA-24351: invalid date passed into OCI call

1 Answers  


ORA-39140: dump file "string" belongs to job string

1 Answers  


QSM-00761: the priority string is invalid for the current operation

1 Answers  






DRG-50917: escape on at end of text query string

1 Answers  


TNS-00014: INTCTL: error while opening terminal input channel

1 Answers  


RMAN-08057: channel string: backup cancelled because all files were skipped

1 Answers  


ORA-07200: slsid: oracle_sid not set.

1 Answers  


ORA-02289: sequence does not exist

1 Answers  


NID-00421: Change of database name failed during validation - database is intact.

1 Answers  


ORA-29661: Unable to find the superclass of the defined in the EXTERNAL NAME

1 Answers  


Categories