File indexing completed on 2024-04-06 12:26:34
0001 CREATE TABLE "CMSRUNSUMMARY"
0002 ( "RUNNUM" NUMBER(10,0),
0003 "HLTKEY" VARCHAR2(128) NOT NULL ENABLE,
0004 "FILLNUM" NUMBER(10,0),
0005 "SEQUENCE" VARCHAR2(56) NOT NULL ENABLE,
0006 "STARTTIME" TIMESTAMP (6),
0007 "STOPTIME" TIMESTAMP (6),
0008 "L1KEY" VARCHAR2(128),
0009 "AMODETAG" VARCHAR2(28),
0010 "EGEV" NUMBER(10,0),
0011 "FILLSCHEME" VARCHAR2(128),
0012 "NCOLLIDINGBUNCHES" NUMBER(10,0),
0013 CONSTRAINT "CMSRUNSUMMARY_PK" PRIMARY KEY ("RUNNUM")
0014 )
0015 PARTITION BY RANGE(RUNNUM)
0016 (
0017 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0018 );
0019 GRANT SELECT ON "CMSRUNSUMMARY" TO PUBLIC;
0020 GRANT SELECT,INSERT,DELETE,UPDATE ON "CMSRUNSUMMARY" TO CMS_LUMI_WRITER;
