Rem drv: <create type="views" pos="stgAdv/stgAdv_views.sql+"/>
Rem
Rem $Header: storage_database_views.sql 28-jun-2005.11:36:52 chyu Exp $
Rem
Rem storage_database_views.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      storage_database_views.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
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    rreilly     03/18/05 - remove dbrollup and controlfiles_size 
Rem    ajdsouza    08/31/04 - anonymous blocks to ignore no object errors on drop
Rem    rmenon      08/27/04 - preceded "create or replace views"
Rem                           lines with "drop view" lines. This is
Rem                           to solve the "ora-600" that
Rem                           we get when compiling the
Rem                           emcores storage_host_ui_pkgbody.sql
Rem    ajdsouza    08/11/04 - ajdsouza_storage_fix
Rem    ajdsouza    08/10/04 - ajdsouza_ecm_processing
Rem    ajdsouza    08/09/04 - Created
Rem

Rem SET ECHO ON
Rem SET FEEDBACK 1
Rem SET NUMWIDTH 10
Rem SET LINESIZE 80
Rem SET TRIMSPOOL ON
Rem SET TAB OFF
Rem SET PAGESIZE 100

BEGIN
EXECUTE IMMEDIATE 'DROP VIEW mgmt_v_db_datafiles_ecm';
EXCEPTION
WHEN OTHERS THEN
 NULL;
END;
/

CREATE OR REPLACE VIEW mgmt_v_db_datafiles_ecm 
(
ecm_snapshot_id,
file_name,
file_size,
os_storage_entity
)
AS
SELECT	ecm_snapshot_id,
        file_name,
        file_size,
        os_storage_entity
FROM mgmt_db_datafiles_ecm
/

BEGIN
EXECUTE IMMEDIATE 'DROP VIEW mgmt_v_db_redologs_ecm';
EXCEPTION
WHEN OTHERS THEN
 NULL;
END;
/

CREATE OR REPLACE VIEW mgmt_v_db_redologs_ecm 
(
ecm_snapshot_id,
file_name,
logsize,
os_storage_entity
)
AS
SELECT	ecm_snapshot_id,
        file_name,
        logsize,
        os_storage_entity
FROM mgmt_db_redologs_ecm
/

BEGIN
EXECUTE IMMEDIATE 'DROP VIEW mgmt_v_db_controlfiles_ecm';
EXCEPTION
WHEN OTHERS THEN
 NULL;
END;
/

CREATE OR REPLACE VIEW mgmt_v_db_controlfiles_ecm 
(
ecm_snapshot_id,
file_name,
os_storage_entity
)
AS
SELECT	ecm_snapshot_id,
        file_name,
        os_storage_entity
FROM mgmt_db_controlfiles_ecm
/


BEGIN
EXECUTE IMMEDIATE 'DROP VIEW mgmt_v_db_dbninstanceinfo_ecm';
EXCEPTION
WHEN OTHERS THEN
 NULL;
END;
/

CREATE OR REPLACE VIEW mgmt_v_db_dbninstanceinfo_ecm 
(
ecm_snapshot_id
)
AS
SELECT	ecm_snapshot_id
FROM    mgmt_db_dbninstanceinfo_ecm 
/

BEGIN
EXECUTE IMMEDIATE 'DROP VIEW mgmt_v_db_tablespaces_ecm';
EXCEPTION
WHEN OTHERS THEN
 NULL;
END;
/

CREATE OR REPLACE VIEW mgmt_v_db_tablespaces_ecm 
(
ecm_snapshot_id,
tablespace_size,
tablespace_used_size
)
AS
SELECT	ecm_snapshot_id,
        tablespace_size,
        tablespace_used_size
FROM    mgmt_db_tablespaces_ecm
/