aiaiDBA

加微信获取免费职业规划+学习资料,了解年薪50万的DBA是如何练成的

13718043309

010-86462881

QSM-02151: subquery or named view in FROM list and < 9.0 compatibility

QSM-02151: subquery or named view in FROM list and < 9.0 compatibility
Cause: You have specified a materialized view that references a subquery or named view in its top level FROM list while running in less than 9.0 compatibility mode.
Action: Set compatibility mode to 9.0 or higher or restructure the materialized view query.

请先 登录 后评论

1 个回答

小智
QSM-02151:FROM列表中的子查询或命名视图和<9.0兼容性,
.原因:在低于9.0的兼容性模式下运行时,您已经指定了一个实体化视图,它引用顶级FROM列表中的子查询或命名视图。,
.操作:将兼容性模式设置为9.0或更高版本或重构物化视图查询。,
.
请先 登录 后评论