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

ORA-14518: partition contains rows corresponding to values being dropped

1 Answers  


QSM-00507: no dimensions could be found

1 Answers  


ORA-13037: SRIDs do not match for the two geometries

1 Answers  


ORA-16020: less destinations available than specified by LOG_ARCHIVE_MIN_SUCCEED_DEST

1 Answers  


KUP-04002: error getting file size for file string

1 Answers  






DRG-50945: Illegal phrase in query for theme index

1 Answers  


ORA-12983: cannot drop all columns in a table

1 Answers  


ORA-09930: LUB of two labels is invalid

1 Answers  


PLS-00485: in exception handler, 'string' must be an exception name

1 Answers  


ORA-07570: szrfc: $IDTOASC failure

1 Answers  


VID-00702: unable to initialize video processing environment

1 Answers  


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

1 Answers  


Categories