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-02182: PCT is enabled through a join dependency



QSM-02182: PCT is enabled through a join dependency..

Answer / guest

Cause: The capability in question is not supported when the
materialized view does not contain some expression join
dependent on the partitioning key of relation in question in
the select list. For definition of join dependency, please
look at Oracle

Action: Change the query to contain the partitioning key

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

PCC-01014: "VARYING" not supported with PIC N PICTURE clause

1 Answers  


ORA-29503: SCHEMA keyword not valid with NAMED keyword

1 Answers  


ORA-04090: 'string' specifies same table, event and trigger time as 'string'

1 Answers  


O2I-00117: Internal error: No message file for component O2U

1 Answers  


NNF-04007: Error reading input file

1 Answers  


DRG-11118: object string does not exist

1 Answers  


ORA-29342: user string does not exist in the database

1 Answers  


ORA-07718: sksafre: error freeing memory

1 Answers  


TNS-00541: underlying transport does not exist.

1 Answers  


ORA-01495: specified chain row table not found

1 Answers  


ORA-07237: slemcl: invalid file handle, seals do not match.

1 Answers  


PLS-00240: Invalid type specification for RETURN indicator, length, tdo, duration

1 Answers  


Categories