Edit D:\app\Administrator\product\11.2.0\dbhome_1\sysman\admin\emdrep\sql\cell\11.2.0.0\cell\cell_schema_upgrade.sql
Rem drv: <migrate type="schema_upgrade" version="11.2.0.0"/> Rem Rem $Header: emtp/oracle_cell/cell/11.2.0.0/cell/cell_schema_upgrade.sql /main/2 2009/03/18 13:45:29 spalapud Exp $ Rem Rem cell_schema_upgrade.sql Rem Rem Copyright (c) 2008, 2009, Oracle and/or its affiliates. Rem All rights reserved. Rem Rem NAME Rem cell_schema_upgrade.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 Rem ysun 10/29/08 - Created Rem CREATE OR REPLACE TYPE emxCellStringAggCollectType AS TABLE OF VARCHAR2(4000) / ------------------ 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