-----------------------------------------
-- Export file for user ZHLIS --
-- Created by du on 2011-3-24, 11:57:35 --
------------------------------------------
spool 112.log
prompt
prompt Creating table AMUS
prompt ===================
prompt
create table ZHLIS.AMUS
(
AMUS NUMBER(10) not null,
NAME VARCHAR2(30) not null,
ISGR NUMBER(5),
ADMN NUMBER(5),
PARN NUMBER(10),
PSWD VARCHAR2(30),
LNAM VARCHAR2(80),
LABL VARCHAR2(254),
LCKD NUMBER(5),
CDAT DATE,
MDAT DATE
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create index ZHLIS.AMUS_NAME on ZHLIS.AMUS (NAME)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create unique index ZHLIS.AMUS_PK on ZHLIS.AMUS (AMUS)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table BLBJ
prompt ===================
prompt
create table ZHLIS.BLBJ
(
BLBJ NUMBER(10) not null,
BTYP NUMBER(5) not null,
MODL NUMBER(10),
TLEN NUMBER(10),
SLEN NUMBER(10),
NSEG NUMBER(10)
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create index ZHLIS.BLBJ_MODL on ZHLIS.BLBJ (MODL)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create unique index ZHLIS.BLBJ_PK on ZHLIS.BLBJ (BLBJ)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table BRSH
prompt ===================
prompt
create table ZHLIS.BRSH
(
BRSH NUMBER(10) not null,
MODL NUMBER(10),
BCLR NUMBER(10),
BSTY NUMBER(10),
BHAT NUMBER(10)
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create index ZHLIS.BRSH_MODL on ZHLIS.BRSH (MODL, BCLR)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create unique index ZHLIS.BRSH_PK on ZHLIS.BRSH (BRSH)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table CNST
prompt ===================
prompt
create table ZHLIS.CNST
(
MODL NUMBER(10) not null,
CNST NUMBER(10) not null,
NAME VARCHAR2(80) not null,
DTTP VARCHAR2(30),
CTGR VARCHAR2(4),
RSRV NUMBER(5),
VALE VARCHAR2(254),
CDAT DATE,
CUSR NUMBER(10),
MDAT DATE,
MUSR NUMBER(10)
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create index ZHLIS.CNST_NAME on ZHLIS.CNST (MODL, NAME)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create unique index ZHLIS.CNST_PK on ZHLIS.CNST (CNST)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table DICTDRUG
prompt =======================
prompt
create table ZHLIS.DICTDRUG
(
MARK VARCHAR2(1),
FLAG VARCHAR2(1),
CODE VARCHAR2(8),
DRGNM VARCHAR2(30),
NCCD VARCHAR2(8)
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 400K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table DOCT
prompt ===================
prompt
create table ZHLIS.DOCT
(
DOCORD VARCHAR2(10) not null,
DOCT VARCHAR2(10) not null
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
prompt
prompt Creating table DWMCSRC
prompt ======================
prompt
create table ZHLIS.DWMCSRC
(
CSRC NUMBER(10) not null,
TSRC NUMBER(10),
COLN NUMBER(10),
CALS VARCHAR2(80),
CEXP NUMBER(10),
INVL NUMBER(5)
)
tablespace TS_JYK
pctfree 10
pctused 40
initrans 1
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create index ZHLIS.DWCSRCOL on ZHLIS.DWMCSRC (COLN)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create unique index ZHLIS.DWCSRPK on ZHLIS.DWMCSRC (CSRC)
tablespace TS_JYK
pctfree 10
initrans 2
maxtrans 255
storage
(
initial 16K
minextents 1
maxextents unlimited
);
create index ZHLIS.DWCSRTSR on ZHLIS.DWMCSRC (TSRC) |
|
資源大小：59.58 KB 
