REM drv: <create type="tables"/>
Rem $Header: util_tables.sql 11-sep-2005.12:14:11 rmaggarw Exp $
Rem
Rem util_tables.sql
Rem
Rem Copyright (c) 2005, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      util_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    rmaggarw    09/11/05 - add module error_master 
Rem    rmaggarw    08/03/05 - rmaggarw_bug-4499396
Rem    rmaggarw    07/28/05 - Created
Rem

CREATE TABLE MGMT_ERROR_MASTER (
    error_start    NUMBER NOT NULL,
    error_end      NUMBER NOT NULL,
    is_recoverable NUMBER(1) DEFAULT 0,
    module         VARCHAR2(64),
    CONSTRAINT mgmt_error_master_pk 
             primary key(error_start, error_end)
) MONITORING;

COMMENT ON TABLE MGMT_ERROR_MASTER IS
  'The MGMT_ERROR_MASTER table constains a list of errors.';

COMMENT ON COLUMN MGMT_ERROR_MASTER.ERROR_START IS
  'Individual errorcode or start of range';

COMMENT ON COLUMN MGMT_ERROR_MASTER.ERROR_END IS
  'Individual errorcode or end of range';

COMMENT ON COLUMN MGMT_ERROR_MASTER.IS_RECOVERABLE IS
  '0 if error code/range is unrecoverable';

COMMENT ON COLUMN MGMT_ERROR_MASTER.MODULE IS
  'null for generic errors, module name for module specific exceptions';