aiaiDBA

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

13718043309

010-86462881

QSM-01281: query rewrite not possible because either a primary key or a row id is required to join table string with MV string

QSM-01281: query rewrite not possible because either a primary key or a row id is required to join table string with MV string
Cause: In order to obtain a missing column, the materialized view needs to join back to the above table. But it lacks the primary key or rowid for the table.
Action: None

请先 登录 后评论

1 个回答

小智
QSM-01281:因为无论主键或行ID必须加入表查询重写不可能串与MV 串,
.原因:为了获得缺少的列,物化视图需要返回到上表。但是它缺少表的主键或rowid。,
.行动:无,
.
请先 登录 后评论