| DDL Code |
CREATE TABLE EPICS.ICS_COMM_OPER_ENV(
DVC_ID VARCHAR2(30) NOT NULL,
COMP_ID VARCHAR2(25),
LIC_OS_USER VARCHAR2(35),
LIC_OS_KEY VARCHAR2(35),
COMP_NM VARCHAR2(25),
OS VARCHAR2(200),
CONN_USER VARCHAR2(100),
MOBO_MDL VARCHAR2(35),
ACLIENT_VER VARCHAR2(25),
BOOTWORK_VER VARCHAR2(25),
PROC_CNT VARCHAR2(10),
BIOS_VER VARCHAR2(50),
BIOS_REL_DTE VARCHAR2(25),
MAIN_DRV_LTR VARCHAR2(10),
MAIN_DRV_SZ VARCHAR2(10),
MAIN_DRV_FREE VARCHAR2(10),
PROC_DESC VARCHAR2(200),
PROC_SPEED VARCHAR2(10),
RAM_TOT VARCHAR2(10),
RAM_FREE VARCHAR2(10),
RES_HORZ VARCHAR2(5),
RES_VERT VARCHAR2(5),
RES_BITSPP VARCHAR2(5),
NIC_DESC VARCHAR2(200),
DATA_READ_SEC VARCHAR2(35),
CPU_TEMP NUMBER(7, 2),
INT_TEMP1 NUMBER(7, 2),
INT_TEMP2 NUMBER(7, 2),
FIRST_FAN NUMBER(7, 2),
SEC_FAN NUMBER(7, 2),
VOLTS2_5 NUMBER(7, 2),
VCORE NUMBER(7, 2),
VOLTS3_3 NUMBER(7, 2),
VOLTS5 NUMBER(7, 2),
VOLTS12 NUMBER(7, 2),
RUNNINGFOR VARCHAR2(50),
BOOT_DTE DATE,
LAST_READ_DTE DATE,
LAST_UPDATE VARCHAR2(25),
CONSTRAINT PK_ICS_COMM_OPER_ENV PRIMARY KEY (DVC_ID)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE EPICS_INDEX_TS
LOGGING
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
CONSTRAINT UNQ_COMP_ID UNIQUE (COMP_ID)
USING INDEX
PCTFREE 10
INITRANS 2
MAXTRANS 255
TABLESPACE EPICS_INDEX_TS
LOGGING
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
),
CONSTRAINT FK_ICS_COMM_OPER_ENV_DVC FOREIGN KEY (DVC_ID)
REFERENCES EPICS.DVC(DVC_ID)
)
PCTFREE 10
PCTUSED 40
INITRANS 1
MAXTRANS 255
TABLESPACE EPICS_TS
LOGGING
NOPARALLEL
STORAGE(INITIAL 64K
NEXT 64K
MINEXTENTS 1
MAXEXTENTS UNLIMITED
PCTINCREASE 0
FREELISTS 1
FREELIST GROUPS 1
BUFFER_POOL DEFAULT
)
NOCACHE
NOCOMPRESS
;
|
