Back up and restore materialized views

When you use the nzbackup command to back up your database, the system backs up the SPM view definition (that is, the schema) like it does with any other view. The system does not back up any SPM view-specific record data.

If you restore the database, the system automatically restores any base tables and re-creates the associated materialized views unless the SPM views were suspended when you created the backup. In that case, the system restores their state as SUSPEND.

If you run a table-level restore on a base table that contains associated SPM views, the system restores the SPM views in their original materialized state, unless you suspend the materialized views, in which case they remain suspended.