File indexing completed on 2023-10-25 10:00:49
0001 CREATE TABLE "HFLUMIRESULT"
0002 ( "RUNNUM" NUMBER(10,0) NOT NULL,
0003 "LS" NUMBER(10,0) NOT NULL ,
0004 "CMSLS" NUMBER(10,0) NOT NULL ,
0005 "FILLNUM" NUMBER(10,0) NOT NULL ,
0006 "TIME" TIMESTAMP(6) NOT NULL ,
0007 "BEAM_STATUS" VARCHAR2(50) NOT NULL,
0008 "ENERGY" NUMBER(10,0) NOT NULL,
0009 "DELIVERED" BINARY_FLOAT,
0010 "RECORDED" BINARY_FLOAT,
0011 "AVG_PU" BINARY_FLOAT,
0012 "DATA_VERSION" VARCHAR2(50) NOT NULL ,
0013 "NORM_VERSION" VARCHAR2(50) NOT NULL ,
0014 "INSERT_TIME" TIMESTAMP NOT NULL ,
0015 CONSTRAINT "HFLUMIRESULT_PK" PRIMARY KEY ("RUNNUM","LS")
0016 )
0017 PARTITION BY RANGE(RUNNUM)
0018 (
0019 PARTITION YEAR2010 VALUES LESS THAN(153368),
0020 PARTITION YEAR2011 VALUES LESS THAN(183338),
0021 PARTITION YEAR2012 VALUES LESS THAN(209310),
0022 PARTITION THEREST VALUES LESS THAN(MAXVALUE)
0023 )
0024 ;
0025 GRANT SELECT ON "HFLUMIRESULT" TO PUBLIC;
0026 GRANT SELECT,INSERT,DELETE,UPDATE ON "HFLUMIRESULT" TO CMS_LUMI_WRITER;
0027 CREATE INDEX HFLUMIRESULT_RUNNUM_IDX ON HFLUMIRESULT(RUNNUM) LOCAL;
0028
0029