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-19550: cannot use backup/restore functions while using dispatcher

1 Answers  


NZE-29044: Renegotiation has already been requested.

1 Answers  


SQL*Loader-00556: unable to allocate read buffer

1 Answers  


QSM-02142: COUNT(*) is not present in the select list

1 Answers  


ORA-12915: Cannot alter dictionary managed tablespace to read write

1 Answers  






ORA-15180: Could not open dynamic library string, error [string]

1 Answers  


ORA-06565: cannot execute string from within stored procedure

1 Answers  


ORA-28537: no more result sets

1 Answers  


ORA-35062: (QFGET01) Duplicate files found for extension number number of EIF file string.

1 Answers  


ORA-19862: backup pieces must be validated before accessing results

1 Answers  


ORA-13243: specified operator is not supported for 3- or higher-dimensional R-tree

1 Answers  


ORA-02448: constraint does not exist

1 Answers  


Categories