PAUSE-MATERIALIZED-VIEW
PAUSE-MATERIALIZED-VIEWβ
Nameβ
PAUSE MATERIALIZED VIEW
Descriptionβ
This statement is used to pause the scheduled scheduling of materialized views
syntax:
PAUSE MATERIALIZED VIEW JOB ON mvName=multipartIdentifier
Exampleβ
Pause scheduled scheduling of materialized view mv1
PAUSE MATERIALIZED VIEW mv1;
Keywordsβ
PAUSE, MATERIALIZED, VIEW