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


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

NNO-00321: statistic counter dump disabled

1 Answers  


ORA-00329: archived log begins at change string, need change string

1 Answers  


TNS-12216: TNS:poorly formed PREFERRED_CMANAGERS addresses in TNSNAV.ORA

1 Answers  


ORA-25020: renaming system triggers is not allowed

1 Answers  


ORA-15092: I/O request size string is not a multiple of logical block size string

1 Answers  






ORA-13001: dimensions mismatch error

1 Answers  


TNS-12632: Role fetch failed

1 Answers  


NNL-00918: Time until server restart: string

1 Answers  


ORA-28132: Merge into syntax does not support security policies.

2 Answers  


ORA-01629: max # extents (string) reached saving undo for tablespace string

1 Answers  


SQL*Loader-00487: COUNT clause required for collection string

1 Answers  


NZE-29049: Unknown record

1 Answers  






Categories