Rem drv:
Rem
Rem $Header: emdb/source/oracle/sysman/emdrep/sql/db/latest/config/config_post_creation.sql /st_emdbsa_11.2/2 2009/02/12 23:34:29 hpalitan Exp $
Rem
Rem config_post_creation.sql
Rem
Rem Copyright (c) 2002, 2009, Oracle and/or its affiliates.
Rem All rights reserved.
Rem
Rem NAME
Rem config_post_creation.sql -
Rem
Rem DESCRIPTION
Rem Contains ECM Metadata Registry.
Rem
Rem NOTES
Rem !!!!!! DO NOT EDIT - THIS IS A GENERATED FILE !!!!!!!!!!
Rem Generated by running MetadataRegistry on
Rem emdrep/sql/db/latest/config/dbconfig_ecm_metadata.xml
Rem
Rem IMPORTANT: Please
Rem 1. Update dbconfig_ecm_metadata.xml based on DTDs published
Rem in the Integrator Guide or Functional Spec
Rem 2. Generate registry statements using MetadataRegistry
Rem 3. Compare the differences between generated output from 2.
Rem and current version, and modify accordingly.
Rem
Rem MODIFIED (MM/DD/YY)
REM amahalin 01/28/09 - Database Vault Changes
REM pbantis 09/30/08 - Retain 11.1 specific fixes.
REM rimmidi 07/29/08 - Code slap from 10205 to 11.2DBControl
REM xshen 08/18/06 - V$PARAMETER.VALUE in 11g is of length 4000
REM xshen 02/22/06 - change banner column
REM pbantis 08/31/05 - Change FLASHBACK_ON size from 3 to 18.
REM chyu 06/28/05 - New repmgr header impl
REM xshen 03/16/05 - fix bug 4244240
REM rreilly 02/21/05 - remove controlfiles_size dbrollup
REM xshen 01/13/05 - turn on history for more attributes
REM xshen 01/13/05 - changing metrics
REM xshen 12/16/04 - sync dbconfig_ecm_metadata.xml
REM xshen 12/13/04 - compare_url correction
REM xshen 12/01/04 - make sure the dbconfig ecm metadata is in sync
REM with the post create registry
REM rreilly 11/19/04 - add new seg management column
REM rreilly 10/08/04 - bug 3941770 move mgmt_db_tablespaces_ecm
REM used_size column to be last
REM akskumar 09/15/04 - insert compare url and view url page types
REM required for generating URLs for view and
REM comparison report page urls
REM rpinnama 06/12/04 - Remove SET ECHO
REM ajdsouza 05/10/04 - add column os_storage_entity
REM sbadrina 05/06/04 - add dbrollup and cfsize
REM xshen 11/12/03 - remove rule fw backend
REM pbantis 10/31/03 - Remove control autobackup rule
REM pbantis 10/24/03 - Add log_mode column to ha_info table
REM xshen 10/03/03 - oracle_dbconfig and oracle_racconfig
REM xshen 10/02/03 - rename snapshot type name
REM xshen 09/19/03 - change ecm mdcolumn for initparam name
REM xshen 08/15/03 - remove DELETE callback registration
Rem pbantis 07/21/03 - Update MGMT_HA_INFO_ECM
Rem xshen 06/16/03 - add next_extent column to ecm metadata
Rem pbantis 06/02/03 - Change recovery area to flash recovery area
Rem xshen 05/27/03 - snapshot based rule method
Rem xshen 05/19/03 - cutting over to snapshot framework
Rem xshen 05/14/03 - consistent rule name with msg string
Rem pbantis 03/24/03 - Add CK_CONTROLFILE_AUTOBACKUP
Rem pbantis 01/14/03 -
Rem pbantis 01/06/03 - Add High Availability rules.
Rem xshen 11/13/02 - minimum number of redolog files 3
Rem xshen 09/24/02 - add delete target callback procedure
Rem xshen 09/18/02 - change level
Rem xshen 09/16/02 - add rule level
Rem xshen 09/11/02 - remove block sum rule
Rem xshen 08/27/02 - modify rule register
Rem xshen 08/19/02 - xshen_dbconfig_rules_create
Rem xshen 08/19/02 - Created
Rem
-- Uncomment the following line to see the commands during the script execution
-- SET ECHO ON
-- Do not use substitution variables in this script so that there is no
-- additional restrictions on the string values that are being inserted (such as ampersand
-- being interpreted specially by SQLPlus).
SET DEFINE OFF
--------------------------------------------
-- Registering metadata Database Configuration for target type oracle_database and snapshot type oracle_dbconfig
--------------------------------------------
ALTER SESSION SET CONSTRAINTS = DEFERRED;
DECLARE
metadata_id RAW(16) := SYS_GUID();
BEGIN
-- Remove all related metadatas
DELETE FROM MGMT_ECM_SNAPSHOT_MD_TABLES WHERE METADATA_ID IN (SELECT METADATA_ID FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_database' AND SNAPSHOT_TYPE = 'oracle_dbconfig');
DELETE FROM MGMT_ECM_SNAPSHOT_METADATA WHERE TARGET_TYPE = 'oracle_database' AND SNAPSHOT_TYPE = 'oracle_dbconfig';
-- Register metadata as loader metadata
INSERT INTO MGMT_ECM_SNAPSHOT_METADATA (SNAPSHOT_TYPE, TARGET_TYPE, KIND, METADATA_ID, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, LINK_TABLE_NAME, AFTER_LOAD_PROC_NAME, AFTER_IMPORT_PROC_NAME, METADATA_VERSION, VIEW_URL, COMPARE_URL, HISTORY_URL, SAME_TARGET_COMPARE)
VALUES ('oracle_dbconfig', 'oracle_database', 'L', metadata_id, 'Database Configuration', 'N', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, '2.0', 'ORACLE_DATABASE_ORACLE_DBCONFIG_VIEW_PAGE', 'ORACLE_DATABASE_ORACLE_DBCONFIG_COMPARE_PAGE', NULL, 'H');
-- Register metadata as presentation metadata
INSERT INTO MGMT_ECM_SNAPSHOT_METADATA (SNAPSHOT_TYPE, TARGET_TYPE, KIND, METADATA_ID, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, LINK_TABLE_NAME, AFTER_LOAD_PROC_NAME, AFTER_IMPORT_PROC_NAME, METADATA_VERSION, VIEW_URL, COMPARE_URL, HISTORY_URL, SAME_TARGET_COMPARE)
VALUES ('oracle_dbconfig', 'oracle_database', 'P', metadata_id, 'Database Configuration', 'N', 'Y', 'Y', 'Y', 'Y', NULL, NULL, NULL, '2.0', 'ORACLE_DATABASE_ORACLE_DBCONFIG_VIEW_PAGE', 'ORACLE_DATABASE_ORACLE_DBCONFIG_COMPARE_PAGE', NULL, 'H');
-- Register metadata for table MGMT_DB_CONTROLFILES_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'Control files', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'N', 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'FILE_NAME', 'File Name', 'S', '512', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'STATUS', 'Status', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'CREATION_DATE', 'Creation Date', 'D', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'SEQUENCE_NUM', 'Sequence Num', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'CHANGE_NUM', 'Change Num', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'MOD_DATE', 'Modification Date', 'D', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_CONTROLFILES_ECM', 'OS_STORAGE_ENTITY', 'OS Storage', 'S', '512', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6);
-- Register metadata for table MGMT_DB_OPTIONS_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_OPTIONS_ECM', 'Database Options', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'N', 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_OPTIONS_ECM', 'NAME', 'Name', 'S', '30', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_OPTIONS_ECM', 'SELECTED', 'Selected', 'S', '5', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
-- Register metadata for table MGMT_HA_INFO_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'High Availability (General Information)', 'N', 'N', 'Y', 'Y', 'Y', NULL, 'Y', 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'DBID', 'Dbid', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'LOG_MODE', 'Log Mode', 'S', '12', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'FORCE_LOGGING', 'Force Logging', 'S', '3', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'DATABASE_ROLE', 'Database Role', 'S', '16', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'FLASHBACK_ON', 'Flashback On', 'S', '18', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INFO_ECM', 'SUPPLEMENTAL_LOGGING', 'Supplemental Logging', 'S', '8', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
-- Register metadata for table MGMT_HA_RMAN_CONFIG_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_HA_RMAN_CONFIG_ECM', 'High Availability (RMAN Configuration)', 'N', 'N', 'Y', 'Y', 'Y', NULL, 'N', 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_RMAN_CONFIG_ECM', 'NAME', 'Name', 'S', '65', 'N', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_RMAN_CONFIG_ECM', 'VALUE', 'Value', 'S', '1025', 'N', 'N', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
-- Register metadata for table MGMT_DB_INIT_PARAMS_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_INIT_PARAMS_ECM', 'Initialization Parameters', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'N', 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_INIT_PARAMS_ECM', 'NAME', 'Name', 'S', '80', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_INIT_PARAMS_ECM', 'VALUE', 'Value', 'S', '4000', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_INIT_PARAMS_ECM', 'ISDEFAULT', NULL, 'S', '9', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
-- Register metadata for table MGMT_DB_DBNINSTANCEINFO_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'Instance Information', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'Y', 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'DATABASE_NAME', 'Database Name', 'S', '9', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'GLOBAL_NAME', 'Global Name', 'S', '4000', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'BANNER', 'Version', 'S', '80', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'HOST_NAME', 'Host', 'S', '64', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'INSTANCE_NAME', 'Instance Name', 'S', '16', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'STARTUP_TIME', 'Instance Startup Time', 'D', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'LOGINS', 'Restricted Mode', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 6);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'LOG_MODE', 'Archive Log Mode', 'S', '12', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 7);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'OPEN_MODE', 'Read Only Mode', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 8);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'DEFAULT_TEMP_TABLESPACE', 'Default Temporary Tablespace', 'S', '30', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 9);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'CHARACTERSET', 'Database Character Set', 'S', '64', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 10);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'NATIONAL_CHARACTERSET', 'National Character Set', 'S', '64', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 11);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DBNINSTANCEINFO_ECM', 'DV_STATUS_CODE', 'Database Vault Status Code', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 12);
-- Register metadata for table MGMT_DB_LICENSE_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_LICENSE_ECM', 'License', 'N', 'N', 'Y', 'N', 'Y', NULL, 'N', 6);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_LICENSE_ECM', 'SESSIONS_MAX', 'Session Max', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_LICENSE_ECM', 'SESSIONS_WARNING', 'Sessions Warning', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_LICENSE_ECM', 'SESSIONS_CURRENT', 'Session Current', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_LICENSE_ECM', 'SESSIONS_HIGHWATER', 'Sessions Highwater', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_LICENSE_ECM', 'USERS_MAX', 'Users Max', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
-- Register metadata for table MGMT_DB_REDOLOGS_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'Redologs', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'N', 7);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'GROUP_NUM', 'Group Num', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'STATUS', 'Status', 'S', '16', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'MEMBERS', 'Members', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'FILE_NAME', 'File Name', 'S', '512', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'ARCHIVED', 'Archived', 'S', '3', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'LOGSIZE', 'Log Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'SEQUENCE_NUM', 'Sequence Num', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'FIRST_CHANGE_SCN', 'First Change SCN', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 7);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'OS_STORAGE_ENTITY', 'OS Storage', 'S', '512', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 8);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_REDOLOGS_ECM', 'THREAD_NUM', 'Thread Num', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 9);
-- Register metadata for table MGMT_DB_ROLLBACK_SEGS_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'Rollback Segments', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'N', 8);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'ROLLNAME', 'Name', 'S', '64', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'STATUS', 'Status', 'S', '16', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'TABLESPACE_NAME', 'Tablespace Name', 'S', '30', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'EXTENTS', 'Extents', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'ROLLSIZE', 'Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'INITIAL_SIZE', 'Initial Size', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'NEXT_SIZE', 'Next Size', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 6);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'MAXIMUM_EXTENTS', 'Maximum Extents', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 7);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'MINIMUM_EXTENTS', 'Minimum Extents', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 8);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'PCT_INCREASE', 'Pct Increase', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 9);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'OPTSIZE', 'Optimal Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 10);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'AVEACTIVE', 'Average Active', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 11);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'WRAPS', 'Wraps', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 12);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'SHRINKS', 'Shrinks', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 13);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'AVESHRINK', 'Average Shrink', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 14);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_ROLLBACK_SEGS_ECM', 'HWMSIZE', 'Hight Water Mark Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 15);
-- Register metadata for table MGMT_DB_SGA_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_SGA_ECM', 'System Global Area', 'N', 'Y', 'Y', 'N', 'Y', NULL, 'N', 9);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_SGA_ECM', 'SGANAME', 'Name', 'S', '64', 'N', 'Y', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_SGA_ECM', 'SGASIZE', 'Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
-- Register metadata for table MGMT_DB_TABLESPACES_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'Tablespaces', 'N', 'Y', 'Y', 'Y', 'Y', NULL, 'N', 10);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'TABLESPACE_NAME', 'Tablespace Name', 'S', '30', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'CONTENTS', 'Contents', 'S', '9', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'STATUS', 'Status', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'EXTENT_MANAGEMENT', 'Extent Management', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'ALLOCATION_TYPE', 'Allocation Type', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'LOGGING', 'Logging', 'S', '10', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'TABLESPACE_SIZE', 'Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'INITIAL_EXT_SIZE', 'Initial Extent', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 7);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'NEXT_EXTENT', 'Next Extent', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 8);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'INCREMENT_BY', 'Increment', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 9);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'MAX_EXTENTS', 'Maximum Extents', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 10);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'TABLESPACE_USED_SIZE', 'Used Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 11);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'SEGMENT_SPACE_MANAGEMENT', 'Segment Space Management', 'S', '6', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 12);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'BLOCK_SIZE', 'Block Size', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 13);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'MIN_EXTENTS', 'Minimum Extents', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 14);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'MIN_EXTLEN', 'Minimum Extent Size', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 15);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_TABLESPACES_ECM', 'BIGFILE', 'Big File', 'S', '3', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 16);
-- Register metadata for table MGMT_DB_DATAFILES_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'Datafiles', 'N', 'Y', 'Y', 'Y', 'Y', 'MGMT_DB_TABLESPACES_ECM', 'N', 11);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'FILE_NAME', 'File Name', 'S', '512', 'N', 'Y', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'STATUS', 'Status', 'S', '9', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'FILE_SIZE', 'Size', 'N', NULL, 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 2);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'AUTOEXTENSIBLE', 'Autoextensible', 'S', '3', 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 3);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'INCREMENT_BY', 'Increment', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 4);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'MAX_FILE_SIZE', 'Max File Size', 'N', NULL, 'N', 'Y', 'Y', 'Y', 'Y', 'N', 'N', 'N', 'N', NULL, 5);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_DB_DATAFILES_ECM', 'OS_STORAGE_ENTITY', 'OS Storage', 'S', '512', 'N', 'Y', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 6);
-- Register metadata for table MGMT_HA_FILES_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_HA_FILES_ECM', 'High Availability - Database Files', 'N', 'N', 'Y', 'N', 'Y', NULL, 'N', 12);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_FILES_ECM', 'NAME', 'Name', 'S', '64', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_FILES_ECM', 'TOTALSIZE', 'Total Size', 'N', NULL, 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
-- Register metadata for table MGMT_HA_INIT_PARAMS_ECM
INSERT INTO MGMT_ECM_SNAPSHOT_MD_TABLES (METADATA_ID, NAME, UI_NAME, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, PARENT_TABLE_NAME, IS_SINGLE_ROW, TBL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INIT_PARAMS_ECM', 'High Availability - Initialization Parameters', 'N', 'N', 'Y', 'N', 'Y', NULL, 'N', 13);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INIT_PARAMS_ECM', 'NAME', 'Name', 'S', '64', 'N', 'N', 'Y', 'N', 'Y', 'Y', 'N', 'N', 'N', NULL, 0);
INSERT INTO MGMT_ECM_SNAPSHOT_MD_COLUMNS (METADATA_ID, TABLE_NAME, NAME, UI_NAME, TYPE, TYPE_FORMAT, UI_ON, COMPARE_ON, COMPARE_UI_ON, HISTORY_ON, HISTORY_UI_ON, IS_KEY, IS_CONTEXT, IS_SUMMARY, IS_CHILD_LINK, LINK_COLUMN_NAME, COL_ORDER)
VALUES (metadata_id, 'MGMT_HA_INIT_PARAMS_ECM', 'VALUE', 'Value', 'S', '512', 'N', 'N', 'Y', 'N', 'Y', 'N', 'N', 'N', 'N', NULL, 1);
END;
/
ALTER SESSION SET CONSTRAINTS = IMMEDIATE;
COMMIT;
-- End of metadata registration for metadata Database Configuration
SET DEFINE ON
-- Update derived materialized views
BEGIN ECM_UTIL.UPDATE_ECM_METADATA; END;
/