|
The section describes enabling and disabling non-materialized views. For information on enabling and disabling materialized views, see Enabling and disabling materialized views.
You can control whether a view is available for use by the database server by enabling or disabling it. When you disable a view, the database server keeps the definition of the view in the database; however, the view is not available for use. If a query explicitly references a disabled view, the query fails and an error is returned. Once a view is disabled, it must be explicitly re-enabled so that the database server can start using it.
If you disable a view, other views that reference it, directly or indirectly, are automatically disabled. Consequently, once you re-enable a view, you must re-enable all other views that were dependent on the view when it was disabled. You can determine the list of dependent views before disabling a view using the sa_dependent_views system procedure. See sa_dependent_views system procedure.
When you enable a view, the database server recompiles it using the definition stored for the view in the database. If compilation is successful, the view status changes to VALID; otherwise, the view remains unchanged. An unsuccessful recompile could indicate that the schema has changed in one or more of the referenced objects. If so, you must change either the view definition or the referenced objects until they are consistent with each other, and then enable the view.
NoteBefore you enable a view, you must re-enable any other views that it references (if they are disabled). |
Connect to the database as a DBA user or as the owner of the view.
Open the Views folder for that database.
Select the view to enable.
Choose File > Recompile and Enable.
Connect to the database as a DBA user or as the owner of the view.
Open the Views folder for that database.
Select the view to disable.
Choose File > Disable.
Connect to the database as a DBA user or as the owner of the view.
Execute an ALTER VIEW ... ENABLE statement.
Connect to the database as a DBA user or as the owner of the view.
Execute an ALTER VIEW ... DISABLE statement.
The following example disables a view called ViewSalesOrders.
ALTER VIEW ViewSalesOrders DISABLE;
The following example re-enables the ViewSalesOrders view.
ALTER VIEW ViewSalesOrders ENABLE;