Rem drv: <create type="views" pos="usage/feature_usage_views.sql+"/>
Rem
Rem $Header: stgAdv_views.sql 28-jun-2005.11:36:51 chyu Exp $
Rem
Rem stgAdv_views.sql
Rem
Rem Copyright (c) 2003, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      stgAdv_views.sql - Storage Advisor view(s)
Rem
Rem    DESCRIPTION
Rem      Creates the view(s) used by Storage Advisor 
Rem      a/k/a Space Advisor
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    abodge      04/29/03 - abodge_add_settings_metrics
Rem    abodge      04/17/03 - Created
Rem

Rem MGMT_SPACE_PURGE exists solely to support an instead-of trigger
Rem that purges records from the MGMT_SPACE_RECORDS table.  When the
Rem trigger is in place and enabled, inserting a row to this view
Rem purges records for the target/metric combination specified by
Rem the two view columns.

CREATE OR REPLACE VIEW mgmt_space_purge AS
  SELECT target_guid, metric_name
  FROM mgmt_space_metrics WITH CHECK OPTION;