Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


QSM-02067: no partition key or PMARKER or join dependent
expression in select list



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

Post New Answer

More Oracle Errors Interview Questions

ORA-06748: TLI Driver: cannot allocate t_discon

1 Answers  


RMAN-06114: changed controlfile copy available

1 Answers  


ORA-12854: Parallel query is not supported on temporary LOBs

1 Answers  


ORA-12322: unable to mount database (link name string)

1 Answers  


NNL-00808: Queries received, all user-defined types: number

1 Answers  






NNL-00548: Displays update request statistics

1 Answers  


PLS-00332: "string" is not a valid prefix for a qualified name

1 Answers  


ORA-25215: user_data type and queue type do not match

1 Answers   WalMart,


ORA-14190: only one ENABLE/DISABLE ROW MOVEMENT clause can be specified

1 Answers  


SQL*Loader-00525: OCI return status: success

1 Answers  


ORA-19677: RMAN configuration name exceeds maximum length of string

1 Answers  


ORA-30379: query txt not specified

1 Answers  






Categories