Report problems to ATLAS LXR Team (with time and IP address indicated)

The LXR Cross Referencer
[ source navigation ]
[ diff markup ]
[ identifier search ]
[ general search ]
 
 
Architecture: [ linux ]
Version: [ head ] [ nightly ] [ GaudiDev ]
  Links to LXR source navigation pages for stable releases [ 12.*.* ]   [ 13.*.* ]   [ 14.*.* ]  
001 -- PROJECT: ATLAS MDT Calibration DB
002 -- AUTHOR: Elisabetta.Vilucchi@lnf.infn.it, celio@roma3.infn.it
003 -- DATE: May 08
004 -- VERSION v1r1
005 
006 --USAGE:
007 --sqlplus <USER_NAME>/<USER_PASSWORD> @mdt_rt_cheby_table.sql <USER_NAME> <SITE_NAME>(2 characters like MU,MI,RM...) <USER_PASSOWRD> <TABLESPCE_NAME>
008 
009 --DROP TABLE &1.."MDT_RT_CHEBY";
010 CREATE TABLE &1.."MDT_RT_CHEBY"
011 ( "MDT_RT_CHEBY_ID"     NUMBER NOT NULL , 
012 "MDT_RT_ID"             NUMBER NOT NULL , 
013 "N_CHEBY_R"             NUMBER(3) NOT NULL , 
014 "N_CHEBY_S"             NUMBER(3) NOT NULL , 
015 "T_MIN"                 NUMBER(5,1) NOT NULL , 
016 "T_MAX"                 NUMBER(5,1) NOT NULL , 
017 "SITE_NAME"             VARCHAR2(2) DEFAULT UPPER('&2') ,
018 "INSERT_TIME"           VARCHAR2(19) ,
019 "CHEBY_COE_R_1"         NUMBER(6,5) NOT NULL , 
020 "CHEBY_COE_R_2"         NUMBER(6,5) NOT NULL , 
021 "CHEBY_COE_R_3"         NUMBER(6,5) NOT NULL , 
022 "CHEBY_COE_R_4"         NUMBER(6,5) NOT NULL , 
023 "CHEBY_COE_R_5"         NUMBER(6,5) NOT NULL , 
024 "CHEBY_COE_R_6"         NUMBER(6,5) NOT NULL , 
025 "CHEBY_COE_R_7"         NUMBER(6,5) NOT NULL , 
026 "CHEBY_COE_R_8"         NUMBER(6,5) NOT NULL , 
027 "CHEBY_COE_R_9"         NUMBER(6,5) NOT NULL , 
028 "CHEBY_COE_R_10"        NUMBER(6,5) NOT NULL , 
029 "CHEBY_COE_R_11"        NUMBER(6,5) NOT NULL , 
030 "CHEBY_COE_R_12"        NUMBER(6,5) NOT NULL , 
031 "CHEBY_COE_R_13"        NUMBER(6,5) NOT NULL , 
032 "CHEBY_COE_R_14"        NUMBER(6,5) NOT NULL , 
033 "CHEBY_COE_R_15"        NUMBER(6,5) NOT NULL , 
034 "CHEBY_COE_R_16"        NUMBER(6,5) NOT NULL , 
035 "CHI_SQUARE_R"          NUMBER(7,2) NOT NULL , 
036 "T_MIN_S"               NUMBER(5,1) NOT NULL , 
037 "T_MAX_S"               NUMBER(5,1) NOT NULL , 
038 "CHEBY_COE_S_1"         NUMBER(6,5) NOT NULL , 
039 "CHEBY_COE_S_2"         NUMBER(6,5) NOT NULL , 
040 "CHEBY_COE_S_3"         NUMBER(6,5) NOT NULL , 
041 "CHEBY_COE_S_4"         NUMBER(6,5) NOT NULL , 
042 "CHEBY_COE_S_5"         NUMBER(6,5) NOT NULL , 
043 "CHEBY_COE_S_6"         NUMBER(6,5) NOT NULL , 
044 "CHEBY_COE_S_7"         NUMBER(6,5) NOT NULL , 
045 "CHEBY_COE_S_8"         NUMBER(6,5) NOT NULL , 
046 "CHI_SQUARE_A"          NUMBER(7,2) NOT NULL , 
047 "R_MIN"                 NUMBER(5,3) NOT NULL , 
048 "R_MAX"                 NUMBER(5,3) NOT NULL , 
049 "CHEBY_COE_T_1"         NUMBER(6,5) NOT NULL , 
050 "CHEBY_COE_T_2"         NUMBER(6,5) NOT NULL , 
051 "CHEBY_COE_T_3"         NUMBER(6,5) NOT NULL , 
052 "CHEBY_COE_T_4"         NUMBER(6,5) NOT NULL , 
053 "CHEBY_COE_T_5"         NUMBER(6,5) NOT NULL , 
054 "CHEBY_COE_T_6"         NUMBER(6,5) NOT NULL , 
055 "CHEBY_COE_T_7"         NUMBER(6,5) NOT NULL , 
056 "CHEBY_COE_T_8"         NUMBER(6,5) NOT NULL , 
057 "CHEBY_COE_T_9"         NUMBER(6,5) NOT NULL , 
058 "CHEBY_COE_T_10"        NUMBER(6,5) NOT NULL , 
059 "CHEBY_COE_T_11"        NUMBER(6,5) NOT NULL , 
060 "CHEBY_COE_T_12"        NUMBER(6,5) NOT NULL , 
061 "CHEBY_COE_T_13"        NUMBER(6,5) NOT NULL , 
062 "CHEBY_COE_T_14"        NUMBER(6,5) NOT NULL , 
063 "CHEBY_COE_T_15"        NUMBER(6,5) NOT NULL , 
064 "CHEBY_COE_T_16"        NUMBER(6,5) NOT NULL , 
065 CONSTRAINT "MDT_RT_CHEBY_ID_SITE_PR" PRIMARY KEY ("MDT_RT_CHEBY_ID", "SITE_NAME") VALIDATE , 
066 CONSTRAINT "MDT_RT_CHEBY_MDT_RT_ID_REF" FOREIGN KEY ("MDT_RT_ID", "SITE_NAME") REFERENCES &1.."MDT_RT" ("MDT_RT_ID", "SITE_NAME") VALIDATE ) 
067 TABLESPACE &4 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) ;
[ source navigation ] [ diff markup ] [ identifier search ] [ general search ]
Due to the LXR bug, the updates fail sometimes to remove references to deleted files. The Saturday's full rebuilds fix these problems
This page was automatically generated by the LXR engine. Valid HTML 4.01!