Skip to main content
Skip to main content

RESUME-MATERIALIZED-VIEW

RESUME-MATERIALIZED-VIEW​

Name​

RESUME MATERIALIZED VIEW

Description​

This statement is used to temporarily restore the scheduled scheduling of materialized views

syntax:

RESUME MATERIALIZED VIEW JOB ON mvName=multipartIdentifier

Example​

  1. Timed scheduling for restoring materialized view mv1

    RESUME MATERIALIZED VIEW JOB ON mv1;

Keywords​

RESUME, MATERIALIZED, VIEW

Best Practice​