Rem drv: <create type="tables"/>
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/net/net_tables.sql /st_emdbsa_11.2/1 2009/11/02 21:48:58 prjaiswa Exp $
Rem
Rem net_tables.sql
Rem
Rem Copyright (c) 2002, 2009, Oracle and/or its affiliates. 
Rem All rights reserved. 
Rem
Rem    NAME
Rem      net_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    prjaiswa    10/22/09 - bug 8905621
Rem    chyu        05/08/06 - RCU Compliant 
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    dkapoor     02/05/03 - dkapoor_impl_net_srvc
Rem    dkapoor     11/08/02 - Created
Rem

Rem ------------------------------------------------------------------------------------------
Rem MGMT_DBNET_TNS_ADMINS holds information regarding the TNS_ADMIN for an Oracle Home 
Rem 				on a Host.
Rem   COLUMNS:
Rem     	HOST_GUID		Unique identification of the HOST.
Rem		ORACLE_HOME	The Oracle Home 
Rem		TNS_ADMIN		The TNS_ADMIN location

CREATE TABLE MGMT_DBNET_TNS_ADMINS
(
  HOST_GUID		RAW(16) DEFAULT SYS_GUID() NOT NULL,
  ORACLE_HOME	VARCHAR2(256) NOT NULL,
  TNS_ADMIN		VARCHAR2(4000)
)
MONITORING;