GP刷新实体视图

有先后调用关系的话,可以多执行几次。

 

REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_zyjszw_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_xl_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_xl_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_count_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_count_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_age_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_zrjs_age_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_jzg_count_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_jzg_count_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_teacher_jzg_bzlb_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_student_suiqian_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_student_schooltype_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_student_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_student_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_student_age_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_school_count_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_class_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_class_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_banxuetiaojian_organization WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_banxuetiaojian_area WITH DATA;
REFRESH MATERIALIZED VIEW mv_dp_baner_area WITH DATA;

posted @ 2021-09-02 11:38  缤纷世界  阅读(98)  评论(0编辑  收藏  举报