-- Create table 告警表
create table OMSFM.TBL_CURRENT_ALARM
(
ALARMSN NUMBER(11) not null,
COUNTER NUMBER(11),
CLEARED NUMBER(1),
CLEARUSER VARCHAR2(90),
ACKED NUMBER(1),
ACKUSER VARCHAR2(90),
ACKTIME NUMBER(20),
LATESTLOGTIME NUMBER(20),
LATESTLOGSN NUMBER(11),
CLEAREDTIME NUMBER(20),
CLEAREDTYPE NUMBER(1),
CLEAREDCLASS NUMBER(1),
SEVERITYCHANGEDTIME NUMBER(20),
MODN VARCHAR2(255) not null,
NEDN VARCHAR2(255),
SOURCE VARCHAR2(255),
OBJECTINSTANCE VARCHAR2(375),
OBJECTCLASS VARCHAR2(128),
NETYPE VARCHAR2(128),
MOVERSION VARCHAR2(128),
NEVERSION VARCHAR2(128),
DEVCSN NUMBER(11),
NOTIFICATIONID NUMBER(11),
EVENTTIME NUMBER(20) not null,
ARRIVEDTIME NUMBER(20),
EVENTTYPE NUMBER(2),
ALARMID NUMBER(11) not null,
ALARMNAME VARCHAR2(150),
PERCEIVEDSEVERITY NUMBER(1),
PROBABLECAUSE NUMBER(11),
DETAILEDINFORMATION VARCHAR2(255),
PROPOSEDREPAIRACTIONS VARCHAR2(255),
BACKEDUPSTATUS NUMBER(1),
SERVICEAFFECTINGINDICATOR NUMBER(1),
ROOTCASEALARMINDICATOR NUMBER(1),
THRESHOLDINFO VARCHAR2(384),
ROOTCASEALARMSN NUMBER(11),
ADDITIONALTEXT VARCHAR2(768),
ADDITIONALINFORMATION VARCHAR2(768),
USERDATA VARCHAR2(1023)
)
tablespace OMSFMDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table OMSFM.TBL_CURRENT_ALARM
add primary key (ALARMSN)
using index
tablespace OMSFMDB
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);
create table OMSFM.TBL_CURRENT_ALARM
(
ALARMSN NUMBER(11) not null,
COUNTER NUMBER(11),
CLEARED NUMBER(1),
CLEARUSER VARCHAR2(90),
ACKED NUMBER(1),
ACKUSER VARCHAR2(90),
ACKTIME NUMBER(20),
LATESTLOGTIME NUMBER(20),
LATESTLOGSN NUMBER(11),
CLEAREDTIME NUMBER(20),
CLEAREDTYPE NUMBER(1),
CLEAREDCLASS NUMBER(1),
SEVERITYCHANGEDTIME NUMBER(20),
MODN VARCHAR2(255) not null,
NEDN VARCHAR2(255),
SOURCE VARCHAR2(255),
OBJECTINSTANCE VARCHAR2(375),
OBJECTCLASS VARCHAR2(128),
NETYPE VARCHAR2(128),
MOVERSION VARCHAR2(128),
NEVERSION VARCHAR2(128),
DEVCSN NUMBER(11),
NOTIFICATIONID NUMBER(11),
EVENTTIME NUMBER(20) not null,
ARRIVEDTIME NUMBER(20),
EVENTTYPE NUMBER(2),
ALARMID NUMBER(11) not null,
ALARMNAME VARCHAR2(150),
PERCEIVEDSEVERITY NUMBER(1),
PROBABLECAUSE NUMBER(11),
DETAILEDINFORMATION VARCHAR2(255),
PROPOSEDREPAIRACTIONS VARCHAR2(255),
BACKEDUPSTATUS NUMBER(1),
SERVICEAFFECTINGINDICATOR NUMBER(1),
ROOTCASEALARMINDICATOR NUMBER(1),
THRESHOLDINFO VARCHAR2(384),
ROOTCASEALARMSN NUMBER(11),
ADDITIONALTEXT VARCHAR2(768),
ADDITIONALINFORMATION VARCHAR2(768),
USERDATA VARCHAR2(1023)
)
tablespace OMSFMDB
pctfree 10
initrans 1
maxtrans 255
storage
(
initial 64
minextents 1
maxextents unlimited
);
-- Create/Recreate primary, unique and foreign key constraints
alter table OMSFM.TBL_CURRENT_ALARM
add primary key (ALARMSN)
using index
tablespace OMSFMDB
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 64K
minextents 1
maxextents unlimited
);