Rem drv: <migrate type="schema_upgrade" version="11.0.0.0"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/11.0.0.0/dg/dg_schema_upgrade.sql /st_emdbsa_11.2/1 2009/01/27 16:16:54 mmootha Exp $
Rem
Rem dg_schema_upgrade.sql
Rem
Rem Copyright (c) 2006, 2008, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      dg_schema_upgrade.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    ngade       12/03/08 - fix upgrade
Rem    sjconnol    08/14/06 - Creation
Rem


Rem Create dg tables
Rem

Rem ------------------------------------------------------------------------------------------
Rem High Availability - Data Guard per-target summary
create table MGMT_HA_DG_TARGET_SUMMARY (
    TARGET_GUID RAW(16) not null,
    COLLECTION_TIMESTAMP date default SYSDATE,
    DB_UNIQUE_NAME varchar2(64),
    PRMY_DB_UNIQUE_NAME varchar2(64),
    ROLE varchar2(64),
    PROTECTION_MODE varchar2(256),
    FSFO_STATUS varchar2(256),
    STATUS varchar2(1024),
    TRANSPORT_LAG NUMBER,
    APPLY_LAG NUMBER,
    constraint MGMT_HA_DG_TARGET_SUMMARY_PK primary key (TARGET_GUID))
    monitoring;

SET DEFINE ON