Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
The General tab of the View property sheet has the following components:
Name Shows the name of the view.
Type Shows the type of object.
Owner Shows the database user who owns the object.
Dbspace Shows the database file (or dbspace) where the materialized view is located. This only applies to materialized views.
Status Shows the status of the object. Values include the following:
Valid The object is available for use by the database server. This status is synonymous with ENABLED. That is, if you ENABLE an object, the status changes to VALID. See View status.
Invalid An attempt to recompile the object after an internal operation has failed, for example, after a schema-altering modification to an object on which it depends. The database server continues to try to recompile the object whenever it is referenced in a statement. See View status.
Disabled The object has been explicitly disabled by the user, for example using an ALTER TABLE ... DISABLE VIEW DEPENDENCIES statement. See View status.
Recompile and Enable Now Click to recompile and enable the view, making it available for use by the database.
Before you enable a view, you must re-enable any other views that it references (if they are disabled). See Enabling and disabling views, or Enabling and disabling materialized views.
Disable Now Click to disable the view. The database server keeps the definition of the view in the database, but makes the view unusable.
Disabling a view can affect queries that explicitly reference it, as well as other views that reference it, directly or indirectly; see Enabling and disabling views, or Enabling and disabling materialized views.
Used in optimization Select this option to indicate whether the materialized view can be used during query optimization. This applies to materialized views only.
Last refresh time Shows the date and time that the view was last refreshed. This applies to materialized views only.
Known stale time Shows the time at which the view became known as stale. This value corresponds to the time at which a change was detected in one of the underlying base tables. This applies to materialized views only.
Comment Provides a place for you to type a description of the view. For example, you could use this area to describe the view's purpose in the system.