Skip to content
≡

Administrator

Developer

Tools

External Tools

ALTER MATERIALIZED VIEW

ALTER MATERIALIZED VIEW#

Syntax#

alter_materialized_view ::=#

alter_mview

Prerequisites#

Only the following users can alter the properties of the materialized view with this statement.

  • The SYS user
  • The ownder of the materialized view
  • The user with the system privilege of ALTER ANY MATERIALIZED VIEW

Description#

By using the ALTER MATERIALIZED VIEW statement, the method and time for refreshing for the existing materialized view can be altered. For more detailed information on each keyword, refer to the description on the CREATE MATERIALIZED VIEW statement.

Examples#

<Query> Alter the refresh method of the materialized view.

ALTER MATERIALIZED VIEW mv1 REFRESH COMPLETE ON DEMAND;