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-30204: buffer is not large enougth

1 Answers  


PCB-00314: DECLARE DATABASE is an Oracle extension

1 Answers  


ORA-09749: pws_look_up: port lookup failure

1 Answers  


ORA-07849: sllfsk: $GET failure

1 Answers  


ORA-19558: error de-allocating device

1 Answers  






RMAN-20205: incomplete UNTIL clause

1 Answers  


ORA-02031: no ROWID for fixed tables or for external-organized tables

1 Answers  


ORA-18003: an outline already exists with this signature

1 Answers  


ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification

1 Answers  


ORA-28555: pass-through SQL: required parameter missing or NULL

1 Answers  


ORA-31643: unable to close dump file "string"

1 Answers  


PLS-00752: Table function string is in an inconsistent state.

1 Answers  


Categories