Initialize a materialized view to populate it with data and make it available for use by the database server. To initialize a materialized view, you follow the same steps as refreshing a materialized view.
You must have DBA authority or have INSERT permission on the materialized view. You must also have SELECT permissions on the underlying objects that the materialized view references.
Context and remarks
You can also initialize all uninitialized materialized views in the database at once using the sa_refresh_materialized_views system procedure.
Before creating, initializing, or refreshing materialized views, ensure that all materialized view restrictions have been met.
Use the SQL Anywhere 12 plug-in to connect to the database.
In the left pane, double-click Views.
Right-click a materialized view and click Refresh Data.
Select an isolation level and click OK.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|