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

SQL*Loader-00415: column string in table string cannot use and be the object of an SDF or LOBFILE

1 Answers  


QSM-01080: invalid dimension, string

1 Answers  


ORA-02167: LOGFILE clause specified more than once

1 Answers  


ORA-39078: unable to dequeue message for agent string from queue "string"

1 Answers  


ORA-12990: duplicate option specified

1 Answers  


ORA-23434: master site string not known for object group

1 Answers  


ORA-19035: Invalid select item of the query in newContextFromHierarchy()

1 Answers  


RMAN-08547: channel string: no autobackups found in the recovery area

1 Answers  


ORA-07623: smscre: $CRMPSC failure

1 Answers  


ORA-01983: invalid auditing option for DEFAULT

1 Answers  


KUP-04073: record ignored because all referenced fields are null for a record

1 Answers  


ORA-07425: sdpri: error string in translating dump file location.

1 Answers  


Categories