Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\cell\latest\cell\cell_tables.sql
Rem drv: <create type="tables"/> Rem Rem $Header: emtp/oracle_cell/cell/latest/cell/cell_tables.sql /main/2 2009/03/18 13:45:28 spalapud Exp $ Rem Rem cell_tables.sql Rem Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem cell_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 spalapud 03/04/09 - remove bmcConfigured column Rem ysun 11/12/08 - Created Rem ------------------ Create Table: MGMT_EMX_CELL_C_CONFIG -------- CREATE TABLE MGMT_EMX_CELL_C_CONFIG ( "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_C_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE, "NAME" VARCHAR2(200), "STATUS" VARCHAR2(200), "REALMNAME" VARCHAR2(200), "ID" VARCHAR2(200), "MAKEMODEL" VARCHAR2(200), "LOCATION" VARCHAR2(200), "BMCTYPE" VARCHAR2(200), "IPBLOCK" VARCHAR2(200), "FANCOUNT" NUMBER, "POWERCOUNT" NUMBER, "METRICHISTORYDAYS" NUMBER, "SNMPSUBSCRIBER" VARCHAR2(200), "SMTPSERVER" VARCHAR2(200), "SMTPPORT" VARCHAR2(200), "IPADDRESS1" VARCHAR2(200), "IPADDRESS2" VARCHAR2(200), "IPADDRESS3" VARCHAR2(200), "IPADDRESS4" VARCHAR2(200), "KERNELVERSION" VARCHAR2(200), "OSSVERSION" VARCHAR2(200), "INTERCONNECTCOUNT" NUMBER, "CPUCOUNT" NUMBER, CONSTRAINT "MGMT_EMX_CELL_C_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID") ) MONITORING ; ------------------ Create Table: MGMT_EMX_CELL_GD_CONFIG -------- CREATE TABLE MGMT_EMX_CELL_GD_CONFIG ( "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_GD_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE, "NAME" VARCHAR2(200), "CELLNAME" VARCHAR2(200), "REALMNAME" VARCHAR2(200), "STATUS" VARCHAR2(200), "GDSIZE" NUMBER, "CREATIONTIME" VARCHAR2(200), "CELLDISK" VARCHAR2(200), "OFFSET" NUMBER, "ERRORCOUNT" NUMBER, "AVAILABLETO" VARCHAR2(200), CONSTRAINT "MGMT_EMX_CELL_GD_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME", "CELLDISK") ) MONITORING ; ------------------ Create Table: MGMT_EMX_CELL_CD_CONFIG -------- CREATE TABLE MGMT_EMX_CELL_CD_CONFIG ( "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_CD_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE, "NAME" VARCHAR2(200), "CELLNAME" VARCHAR2(200), "REALMNAME" VARCHAR2(200), "STATUS" VARCHAR2(200), "CDSIZE" VARCHAR2(200), "LUN" VARCHAR2(200), "ERRORCOUNT" NUMBER, "FREESPACE" NUMBER, "DEVICEPARTITION" VARCHAR2(200), CONSTRAINT "MGMT_EMX_CELL_CD_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME") ) MONITORING ; ------------------ Create Table: MGMT_EMX_CELL_L_CONFIG -------- CREATE TABLE MGMT_EMX_CELL_L_CONFIG ( "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_L_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE, "NAME" VARCHAR2(200), "CELLNAME" VARCHAR2(200), "REALMNAME" VARCHAR2(200), "STATUS" VARCHAR2(200), "ID" VARCHAR2(200), "CELLDISK" VARCHAR2(200), "ERRORCOUNT" NUMBER, "RAIDLEVEL" VARCHAR2(200), "DEVICENAME" VARCHAR2(200), "LUNSIZE" NUMBER, "LUNUID" VARCHAR2(200), "LUNAUTOCREATE" VARCHAR2(200), "PHYSICALDISKS" VARCHAR2(1000), CONSTRAINT "MGMT_EMX_CELL_L_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME") ) MONITORING ; ------------------ Create Table: MGMT_EMX_CELL_PD_CONFIG -------- CREATE TABLE MGMT_EMX_CELL_PD_CONFIG ( "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_PD_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE, "NAME" VARCHAR2(200), "CELLNAME" VARCHAR2(200), "REALMNAME" VARCHAR2(200), "STATUS" VARCHAR2(200), "ID" VARCHAR2(200), "MAKEMODEL" VARCHAR2(200), "LUNS" VARCHAR2(1000), "ERRORCOUNT" VARCHAR2(200), "CTRLFIRMWARE" VARCHAR2(200), "CTRLHWVERSION" VARCHAR2(200), "PHYSINTERFACE" VARCHAR2(200), "PHYSFIRMWARE" VARCHAR2(200), "PHYSSIZE" VARCHAR2(200), "PHYSSERIAL" VARCHAR2(200), "PHYSUSETYPE" VARCHAR2(200), "PHYSPORT" VARCHAR2(200), "PHYSINSERTTIME" VARCHAR2(200), CONSTRAINT "MGMT_EMX_CELL_PD_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME") ) MONITORING ; ------------------ Create Table: MGMT_EMX_CELL_IORM_CONFIG -------- CREATE TABLE MGMT_EMX_CELL_IORM_CONFIG ( "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_EMX_CELL_IORM_CONFIG0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE, "NAME" VARCHAR2(200), "CELLNAME" VARCHAR2(200), "REALMNAME" VARCHAR2(200), "STATUS" VARCHAR2(200), "LATENCY" VARCHAR2(200), "DIRECTIVETYPE" VARCHAR2(200), "DBCATNAME" VARCHAR2(200), "LEVEL1" VARCHAR2(200), "LEVEL2" VARCHAR2(200), "LEVEL3" VARCHAR2(200), "LEVEL4" VARCHAR2(200), "LEVEL5" VARCHAR2(200), "LEVEL6" VARCHAR2(200), "LEVEL7" VARCHAR2(200), "LEVEL8" VARCHAR2(200), "ROLE" VARCHAR2(200), CONSTRAINT "MGMT_EMX_CELL_IORM_CONFIG_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "NAME", "CELLNAME", "REALMNAME", "DIRECTIVETYPE", "DBCATNAME") ) MONITORING ; -- End of table (re)creation for metadata Oracle Cell Configuration
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de