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

DRG-11515: not enough text key values

1 Answers  


QSM-02069: PCT not supported with multi-column partition key

1 Answers  


ORA-36270: (XSCGMDLAGG03) The right-hand side of the AGGREGATION function includes duplicate values.

1 Answers  


ORA-30991: cannot use DOM to add special attribute to schema-based parent

1 Answers  


ORA-28150: proxy not authorized to connect as client

1 Answers  


DRG-50933: parser hash insert failure

1 Answers  


ORA-32102: invalid OCI handle

2 Answers  


PLS-00532: Target of REF must be a complete or incomplete object type.

1 Answers  


ORA-24154: rule string.string already in rule set string.string

1 Answers  


ORA-19810: Cannot create temporary controlfile file string in DB_RECOVERY_FILE_DEST

1 Answers  


ORA-00300: illegal redo log block size string specified - exceeds limit of string

1 Answers  


ORA-38727: FLASHBACK DATABASE requires a current control file.

1 Answers  


Categories