Change materialized views

You cannot do direct record inserts, updates, or truncates on materialized views or their associated materialized tables.

• If you delete records in the base table, either as part of a record update or record delete operation, the system propagates the change to all the appropriate materialized records in the unsuspended SPM views.
• If you truncate records in the base table, the system truncates the materialized tables for the associated SPM views.