ποΈ ALTER MATERIALIZED VIEW
ALTER MATERIALIZED VIEW can:
ποΈ CANCEL REFRESH MATERIALIZED VIEW
CANCEL REFRESH MATERIALIZED VIEW cancels a refresh task for an asynchronous materialized view.
ποΈ CREATE MATERIALIZED VIEW
CREATE MATERIALIZED VIEW creates a materialized view. For usage information about materialized views, see Synchronous materialized view and Asynchronous materialized view.
ποΈ DROP MATERIALIZED VIEW
DROP MATERIALIZED VIEW drops a materialized view.
ποΈ REFRESH MATERIALIZED VIEW
REFRESH MATERIALIZED VIEW manually refreshes a specific asynchronous materialized view or partitions within.
ποΈ SHOW ALTER MATERIALIZED VIEW
SHOW ALTER MATERIALIZED VIEW shows the building status of synchronous materialized views.
ποΈ SHOW CREATE MATERIALIZED VIEW
SHOW CREATE MATERIALIZED VIEW shows the definition of a specific asynchronous materialized view.
ποΈ SHOW MATERIALIZED VIEWS
SHOW MATERIALIZED VIEWS shows all or one specific asynchronous materialized view.