LumiDB/doc/trghltmaptables.sql

0001 /*==========================TRGHLTMAP======================*/
0002 CREATE TABLE "TRGHLTMAP"
0003 ("HLTKEY" VARCHAR2(128) NOT NULL ENABLE,
0004 "HLTPATHNAME" VARCHAR2(256) NOT NULL ENABLE,
0005 "L1SEED" VARCHAR2(1024) NOT NULL ENABLE,
0006  CONSTRAINT "TRGHLTMAP_PK" PRIMARY KEY ("HLTKEY","HLTPATHNAME","L1SEED")
0007 )
0008 PARTITION BY HASH(HLTKEY)
0009 PARTITIONS 4
0010 STORE IN (CMS_LUMI_PROD_DATA,CMS_LUMI_PROD_DATA,CMS_LUMI_PROD_DATA,CMS_LUMI_PROD_DATA)
0011 ;
0012 GRANT SELECT ON "TRGHLTMAP" TO PUBLIC;
0013 GRANT SELECT,INSERT,DELETE,UPDATE ON "TRGHLTMAP" TO CMS_LUMI_WRITER;