暂无图片

QSM-03280:One or more materialized views failed to refresh successfully.

错误码

错误描述:One or more materialized views failed to refresh successfully.
错误原因:The base tables in the group refreshed successfully but one or more materialized views in the group did not. The status of the group for synchronous refresh operation was set to PARTIAL in this case.
解决方法:To find the materialized views which failed, query the USER_SR_OBJ_STATUS catalog view. Take one of the following courses of action:* Issue the EXECUTE_REFRESH command again to retry refreshing the views. In this case EXECUTE_REFRESH will internally use the PCT refresh mode to refresh the materialized views.* Issue the ABORT_REFRESH command to abort the refresh of all objects in the group, including the base tables, and restore them to the original state.

向认证技术专家提问

向技术专家提问

相关搜索
查看更多》