001
002
003
004
005
006
007
008
009
010 CREATE TABLE &1.."MDT_RT"
011 ("MDT_RT_ID" NUMBER NOT NULL ,
012 "REGION_ID" NUMBER NOT NULL ,
013 "HEAD_ID" NUMBER NOT NULL ,
014 "LOWRUN" NUMBER(8) NOT NULL ,
015 "UPRUN" NUMBER(8) NOT NULL ,
016 "HISTOGRAM" VARCHAR2(4000) NOT NULL ,
017 "N_SEGS" NUMBER(7) NOT NULL ,
018 "AVER_ANGLE" NUMBER(6,5) NOT NULL ,
019 "DELTA_AVER_ANGLE" NUMBER(6,5) NOT NULL ,
020 "AVER_SPREAD" NUMBER(6,5) NOT NULL ,
021 "DELTA_AVER_SPREAD" NUMBER(6,5) NOT NULL ,
022 "CONVERGENCE" NUMBER(7,4) NOT NULL ,
023 "B_AVER" NUMBER(3,2) NOT NULL ,
024 "T_AVER" NUMBER(5,2) NOT NULL ,
025 "HV" NUMBER(6,2) NOT NULL ,
026 "CURR" NUMBER(10,9) NOT NULL ,
027 "GAS" NUMBER(5,2) NOT NULL ,
028 "CALIBFLAG" NUMBER(3) DEFAULT 0 NOT NULL ,
029 "VALIDFLAG" NUMBER(3) DEFAULT 0 NOT NULL ,
030 "SITE_NAME" VARCHAR2(2) DEFAULT UPPER('&2') ,
031 "INSERT_TIME" VARCHAR2(19),
032 CONSTRAINT "MDT_HEAD_RT_ID_REF" FOREIGN KEY ("HEAD_ID", "SITE_NAME") REFERENCES &1.."MDT_HEAD" ("HEAD_ID", "SITE_NAME") VALIDATE ,
033 CONSTRAINT "MDT_RT_ID_SITE_PR" PRIMARY KEY ("MDT_RT_ID", "SITE_NAME") VALIDATE ,
034 CHECK ("UPRUN" >= "LOWRUN") VALIDATE )
035 TABLESPACE &4 PCTFREE 10 INITRANS 1 MAXTRANS 255 STORAGE ( INITIAL 64K BUFFER_POOL DEFAULT) LOGGING;
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.
|
|