Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-04014: descending sequences that CYCLE must specify MINVALUE

1 Answers  


TNS-00294: Connection Manager: Security is enabled, you cannot STOP the Interchange

1 Answers  


IMG-00732: specified inputChannels could not be found in input image

1 Answers  


IMG-00911: free basic data structure failed

1 Answers  


ORA-22979: cannot INSERT object view REF or user-defined REF

1 Answers  


ORA-14298: LOB column block size mismatch in ALTER TABLE EXCHANGE [SUB]PARTITION

1 Answers  


ORA-14173: illegal subpartition-extended table name syntax

1 Answers  


ORA-31408: invalid value specified for begin_scn or end_scn

1 Answers  


DRG-10313: logging has already been started

1 Answers  


IMP-00032: SQL statement exceeded buffer length

1 Answers  


ORA-36873: (XSTFDSC03) Column type must be specified explicitly.

1 Answers  


ORA-10646: Too many recursive extensions during SYSTEM tablespace migration

1 Answers  


Categories