Rem drv: <create type="tables" pos="stgAdv/stgAdv_tables.sql+"/>
Rem
Rem $Header: dirobj_tables.sql 28-jun-2005.10:39:38 chyu Exp $
Rem
Rem dirobj_tables.sql
Rem
Rem Copyright (c) 2004, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      dirobj_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    chyu        06/28/05 - New repmgr header impl 
Rem    gan         08/20/04 - add monitoring 
Rem    schaudhr    07/15/04 - Added target guid as column 
Rem    schaudhr    05/06/04 - schaudhr_dirobj_rep_table
Rem    schaudhr    05/06/04 - Created
Rem

CREATE TABLE sysman.MGMT_DIROBJ_USERS_HOTLIST
    (
    TARGET_GUID RAW(16)   NOT NULL, 
    dir_name VARCHAR2(30) NOT NULL,
    user_name VARCHAR2(30) NOT NULL,
    CONSTRAINT mgmt_dirobj_users_hotlist_pk primary key( TARGET_GUID,dir_name,user_name)
    )
    ORGANIZATION INDEX MONITORING;