Rem drv: <create type="tables"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/dg/dg_tables.sql /st_emdbsa_11.2/2 2009/02/02 13:16:15 gallison Exp $
Rem
Rem dg_tables.sql
Rem
Rem Copyright (c) 2002, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      dg_tables.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/01/08  - Move create tables into latest
Rem    ngade       09/25/08 -  "Code slap 10.2.0.5.0 -> 11.2SA"
Rem    rimmidi     05/13/08 - 
Rem    ngade       05/12/08 - Code slap 11g-10.2.0.5
Rem    chyu        10/14/07 - adding the factored out new 11g table back
Rem    sjconnol    07/24/06 - Move content to upgrade script
Rem    sjconnol    08/14/06 - Creation
Rem

Rem ------------------------------------------------------------------------------------------
Rem Create dg tables
Rem
create table MGMT_HA_DG_TARGET_SUMMARY (
    TARGET_GUID RAW(16) not null,
    COLLECTION_TIMESTAMP date default SYSDATE,
    SOURCE_TYPE varchar2(2),
    ROW_TYPE varchar2(2),
    USING_BROKER varchar2(4),
    ACTIVE_STBY varchar2(4),
    DB_UNIQUE_NAME varchar2(64),
    DB_ID NUMBER,
    PRMY_DB_UNIQUE_NAME varchar2(64),
    PRMY_DB_ID NUMBER,
    ROLE varchar2(64),
    STBY_LIST varchar2(1024),
    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;