1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44
|
create table cdt (
num int not null
,cde int not null
,liv int not null
,lieuc varchar2(5) not null
,bapt varchar2(3) not null
,id_contenant int not null
,env_transp_int varchar2(1)
,recu_transp_int varchar2(1)
,ctr_exp varchar2(1)
,selection varchar2(1)
,date_recep date
,code_chauf varchar2(5)
,lib_chauf varchar2(50)
,num_trajet number
,lib_trajet varchar2(50)
,qte number
,incomplet varchar2(1)
,pret_tint varchar2(1)
,etitrac varchar2(1)
,ed_etiquette varchar2(1)
)
tablespace tracabilite
storage (initial 1M next 500K pctincrease 0);
drop public synonym cdt;
create public synonym cdt for ops$projet.cdt;
grant all on cdt to minier;
drop index k_cdt;
create index k_cdt on cdt(num) tablespace clindex
storage (initial 200K next 200K pctincrease 0);
drop index k2_cdt;
create index k2_cdt on cdt(cde,liv) tablespace clindex
storage (initial 200K next 200K pctincrease 0);
rem MODIF : 05-2004 : GE : AJOUT D'UNE CONTRAINTE INTEGRITE
alter table cdt drop constraint k_cdt4;
alter table cdt add constraint k_cdt4
primary key (cde,liv,lieuc,bapt,id_contenant)
using index tablespace clindex
storage (initial 200K next 200K pctincrease 0); |
Partager