QSM-02182: PCT is enabled through a join dependency

QSM-02182: PCT is enabled through a join dependency
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 documentation.
Action: Change the query to contain the partitioning key

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 18:55

QSM-02182：通过连接依赖关系启用PCT,
.原因：当实体化视图不包含某些表达式连接时，不支持该问题的能力，这取决于选择列表中相关关系的分区关键字。有关连接依赖关系的定义，请查看Oracle文档。,
.操作：将查询更改为包含分区键,
.

aiaiDBA

13718043309

010-86462881

QSM-02182: PCT is enabled through a join dependency

1 个回答

相似问题