Rem drv: <create type="tables" pos="config/config_tables.sql+"/>
Rem ----------------------------------------------------------------------------
Rem
Rem $Header: feature_usage_tables.sql 28-jun-2005.10:39:37 chyu Exp $
Rem
Rem feature_usage_tables.sql
Rem
Rem Copyright (c) 2002, 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      feature_usage_tables.sql
Rem
Rem    DESCRIPTION
Rem
Rem    NOTES
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    chyu        06/28/05 - New repmgr header impl 
Rem    jstone      05/14/03 - add rac support
Rem    jstone      04/29/03 - beta 2 revisions
Rem    jstone      03/25/03 - fixes constraint
Rem    jstone      03/24/03 - jstone_030324_feature_usage_search
Rem    jstone      05/15/02 - Created
Rem
Rem ----------------------------------------------------------------------------

Rem ----------------------------------------------------------------------------
Rem          D a t a b a s e   F e a t u r e   U s a g e   T a b l e 
Rem ----------------------------------------------------------------------------

create table MGMT_DB_FEATUREUSAGE (
  TARGET_GUID          RAW(16)               not null ,
  COLLECTION_TIMESTAMP date default SYSDATE           ,
  DBID                 NUMBER                not null ,
  NAME                 VARCHAR2(64)          not null ,
  CURRENTLY_USED       VARCHAR2(5)                    ,
  DETECTED_USAGES      NUMBER                not null ,
  FIRST_USAGE_DATE     DATE                           ,
  LAST_USAGE_DATE      DATE                           ,
  VERSION              VARCHAR2(17)          not null ,
  LAST_SAMPLE_DATE     DATE                           ,
  LAST_SAMPLE_PERIOD   NUMBER                         ,
  TOTAL_SAMPLES        NUMBER                not null ,
  AUX_COUNT            NUMBER                         ,
  DESCRIPTION          VARCHAR(128)                   ,
  constraint 
    MGMT_DB_FEATUREUSAGE_PK primary key (TARGET_GUID, NAME, DBID, VERSION)
  )
  monitoring;

Rem ----------------------------  End of File  ---------------------------------