aiaiDBA

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

13718043309

010-86462881

QSM-01353: no query rewrite on remote objects unless integrity mode is set to stale_tolerated

QSM-01353: no query rewrite on remote objects unless integrity mode is set to stale_tolerated
Cause: Query rewrite's integrity mode should be set to stale_tolerated for query rewrite to occur on queries with remote objects
Action: Set the session parameter, QUERY_REWRITE_INTEGRITY to stale_tolerated

请先 登录 后评论

1 个回答

小智
QSM-01353:在完整模式设置为stale_tolerated之前,不对远程对象进行查询重写,
.原因:查询重写的完整性模式应设置为stale_tolerated,以便查询重写发生在具有远程对象的查询上,
.操作:将会话参数QUERY_REWRITE_INTEGRITY设置为stale_tolerated,
.
请先 登录 后评论