-------------------------- 现在版本
DROP TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT";
DROP TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT";
CREATE TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT"
(
"SLI_ID" VARCHAR2(60) NOT NULL,
"AGG_TT_ID" NUMBER(38,0) NOT NULL,
"RECORD_STATUS" NUMBER(1,0) NOT NULL,
"INCIDENT_TIME" TIMESTAMP (6) NOT NULL,
"INSERT_TIME" TIMESTAMP (6) NOT NULL,
"PRE_INCIDENT_TIME" TIMESTAMP (6),
"UPDATE_SEQ" NUMBER(38,0) NOT NULL,
"SLA_GROUP_ID" VARCHAR2(50) NOT NULL,
"CAUSE_CODE" VARCHAR2(60),
PRIMARY KEY ("AGG_TT_ID")
);
CREATE UNIQUE INDEX "SCAL_SLAM_SLA"."IDX_INCIDENT_UPDATE_SEQ" ON "SCAL_SLAM_SLA"."SLI_INCIDENT" ("UPDATE_SEQ");
CREATE SEQUENCE "SCAL_SLAM_SLA"."SQ_SLI_INCIDENT" MINVALUE 1 MAXVALUE 999999999999999999999999999 INCREMENT BY 1 START WITH 240 CACHE 20 NOORDER NOCYCLE ;
----------------------------------原来版本
--------------------------------------------------
CREATE TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT"
( "ID" NUMBER(38,0) NOT NULL ENABLE,
"SLI_ID" VARCHAR2(60) NOT NULL ENABLE,
"RAWEVENT_ID" VARCHAR2(100),
"INCIDENT_TIME" TIMESTAMP (6) NOT NULL ENABLE,
"IS_DELETED" CHAR(1) NOT NULL ENABLE,
"INSERT_TIME" TIMESTAMP (6) NOT NULL ENABLE,
"PRE_EVENT_TIME" TIMESTAMP (6),
"CAUSE_CODE" VARCHAR2(60),
PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE,
CONSTRAINT "SLI_INCIDENT_ID_FK" FOREIGN KEY ("SLI_ID")
REFERENCES "SCAL_SLAM_SLA"."SLI" ("ID") ENABLE
) PCTFREE 10 PCTUSED 0 INITRANS 1 MAXTRANS 255 NOCOMPRESS LOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
CREATE UNIQUE INDEX "SCAL_SLAM_SLA"."SYS_C0014047" ON "SCAL_SLAM_SLA"."SLI_INCIDENT" ("ID")
PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ;
ALTER TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT" MODIFY ("ID" NOT NULL ENABLE);
ALTER TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT" MODIFY ("SLI_ID" NOT NULL ENABLE);
ALTER TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT" MODIFY ("INCIDENT_TIME" NOT NULL ENABLE);
ALTER TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT" MODIFY ("IS_DELETED" NOT NULL ENABLE);
ALTER TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT" MODIFY ("INSERT_TIME" NOT NULL ENABLE);
ALTER TABLE "SCAL_SLAM_SLA"."SLI_INCIDENT" ADD PRIMARY KEY ("ID")
USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "USERS" ENABLE;
分享到:
相关推荐
u-boot.bin_tekkaman_2009.11.bz2 参考网站:Tekkaman Ninja github.com/tekkamanninja 直接可用于mini2440开发板 当然在这之前首先必须保证你的开发板上已经有了U-boot。如果没有,就请先烧入一个 已经编译好...
ntfs-3g-2009.11.14.tgz Linux挂载ntfs 最新工具
McGraw.Hill.Oracle.Data.Guard.11g.Handbook.Jul.2009.pdf
此次的u-boot-2009.11_xiaomin_mini2440所实现的功,特性归纳如下: 1、同时支持S3C2410和S3C2440 (2410没板测试) 2、自动识别S3C2440的启动方式,并能够将环境变量的保存到对应的位置 3、支持网卡芯片DM9000 4、...
(原)uboot-2009.11移植手册(适用于Mirco2440,Mini2440,TQ2440)
IBExpert 2009.11.02处理版 IBExpert 2009.11.02处理版
— IEEE Std 802.11wTM-2009: Protected Management Frames (Amendment 4) — IEEE Std 802.11nTM-2009: Enhancements for Higher Throughput (Amendment 5) — IEEE Std 802.11pTM-2010: Wireless Access in ...
导航仪RMVB插件播放工具2009.11.11可以播放RMVB格式的导航仪专用小软件
精美PPT模板_2009.11.30
802.11-2007,共1200多页,用于替代下面标准: IEEE 802.11-1999、 ...后面还有802.11k-2008 802.11r-2008 802.11y-2008 802.11w-2009 等标准,资源来自IEEE官方网站,全都整理在这里了。免去了大家查找的辛苦。
达内学习笔记(corejava) 2009.11 达内学习笔记(corejava) 2009.11 达内学习笔记(corejava) 2009.11 达内学习笔记(corejava) 2009.11 达内学习笔记(corejava) 2009.11 达内学习笔记(corejava) ...
本人自己移植的uboot,完成针对mini2440板子,支持nand flash,nor flash,usb,键盘,dm9000,sd卡。主要有开机logo,图片能在屏幕上正确显示。
最新的uboot,集成了所有uboot的功能,支持大多数班子,网卡DM9000AE的支持
IEEE 2009年批准的802.11n标准。
SPI_TEST_BIN.2009.11.25.rar
IEEE Std 802.11n™-2009.pdf
802.11w-2009 IEEE Standard for Information Technology— Part 11: Wireless LAN Medium Access Control (MAC) and Physical Layer (PHY) Specifications Amendment 4: Protected Management Frames This ...
GJB150.11A-2009第11部分:盐雾试验.pdf
精美PPT模板_2009.11.30 打包