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-30649: missing DIRECTORY keyword

1 Answers  


ORA-13358: circle type does not contain 3 points

1 Answers  


ORA-09914: Unable to open the ORACLE password file.

1 Answers  


LPX-00002: out of memory

1 Answers  


ORA-06732: TLI Driver: cannot alloc t_discon

1 Answers  






ORA-32338: on commit refresh grab all the detailed tables

1 Answers  


RMAN-08599: channel string: throttle time: string

1 Answers  


NNF-01006: Attribute string not available

1 Answers  


IMG-00516: default channel out of range

1 Answers  


ORA-06436: ssaio: asynchronous I/O failed due to incorrect parameters.

1 Answers  


TNS-12204: TNS:received data refused from an application

1 Answers  


RMAN-00570: **end-of-file**

1 Answers  


Categories