Rem drv: <create type="tables" pos="sec/dirobj_tables.sql+"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/ob/ob_tables.sql /st_emdbsa_11.2/2 2009/03/04 19:53:18 swbalasu Exp $
Rem
Rem ob_tables.sql
Rem
Rem Copyright (c) 2002, 2009, Oracle and/or its affiliates.
Rem All rights reserved. 
Rem
Rem    NAME
Rem      ob_tables.sql
Rem
Rem    DESCRIPTION
Rem      Oracle Backup schema tables.
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    swbalasu    03/01/09 - bug 7702321
Rem    swbalasu    10/29/08 - bug 7498153
Rem    swbalasu    09/10/08 - 
Rem    pfgavin     07/07/08 - add constraint
Rem    swbalasu    02/14/08 - MGMT_OB_ADMIN_HOSTS table is obsolete after OSB
Rem                           as target
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    pbantis     03/28/05 - Store db guid instead of db id in 
Rem                           MGMT_OB_ADMIN_CLIENT_DB. 
Rem    pfgavin     12/15/04 - make hostname unique 
Rem    pfgavin     08/09/04 - pfgavin_ob_oconf_040614
Rem    pfgavin     07/19/04 - Created
Rem

-- List of targets that are registered with an admin host.
-- Referenced from emo/ob/ObObject
CREATE TABLE MGMT_OB_ADMIN_CLIENT_DB (
  OB_TARGET_GUID         RAW(16) NOT NULL,
  OB_CLIENT_HOST         VARCHAR(128),
  OB_ADMIN_TARGET_GUID   RAW(16) NOT NULL,
  CONSTRAINT MGMT_OB_ADMIN_CLIENT_DB PRIMARY KEY(OB_TARGET_GUID, OB_ADMIN_TARGET_GUID)
) MONITORING;

CREATE INDEX MGMT_OB_ADMIN_CLIENT_DB_IX1 on MGMT_OB_ADMIN_CLIENT_DB(OB_ADMIN_TARGET_GUID);