PAUSE MATERIALIZED VIEW
Descriptionβ
This statement is used to pause the scheduled scheduling of materialized views
Syntaxβ
PAUSE MATERIALIZED VIEW JOB ON <mv_name>
Required Parametersβ
1. <mv_name>
Specifies the materialized view name.
The materialized view name must start with a letter character (or any language character if unicode name support is enabled) and cannot contain spaces or special characters unless the entire materialized view name string is enclosed in backticks (e.g.,
My Object).The materialized view name cannot use reserved keywords.
For more details, see Reserved Keywords.
Access Control Requirementsβ
Users executing this SQL command must have at least the following privileges:
| Privilege | Object | Notes |
|---|---|---|
| ALTER_PRIV | Materialized View | PAUSE is an ALTER operation on a materialized view |
Usage Notesβ
- After you use this statement, you can use the RESUME materialized view statement to restore.
Exampleβ
-
Pause scheduled scheduling of materialized view mv1
PAUSE MATERIALIZED VIEW JOB ON mv1;
