8.3.1 Création des tables

create table cep_horiz
(date_maj date,
date_don date not null,
reseau	varchar2(6) not null,
lon	number ,
lat	number ,
u1000	number ,
v1000	number ,
u0850	number ,
v0850	number ,
u0200	number ,
v0200	number )
tablespace data_cep
pctfree	2
pctused	3
storage ( initial 100M next 2M
	pctincrease 0 );

create table cep_merid
(date_maj date,
date_don date not null,
reseau	varchar2(6) not null,
lat	number ,
niv	number ,
t	number ,
u	number ,
v	number ,
w	number ,
r	number ,
vo	number ,
dv	number )
tablespace data_cep
pctfree	2
pctused	3
storage ( initial 10M next 500K
	pctincrease 0 );

create table cep_zonal
(date_maj date,
date_don date not null,
reseau	varchar2(6) not null,
lon	number ,
niv	number ,
t	number ,
u	number ,
v	number ,
w	number ,
r	number ,
vo	number ,
dv	number )
pctfree	2
pctused	3
tablespace data_cep
storage ( initial 15M next 500K
	pctincrease 0 );

create table RS_OMEGA
(DATE_MAJ    date,
 SITE        varchar2(10) not null,
 DATE_LACHER date not null,
 DATE_RESEAU date,
 CHRONO      number,
 P           number,
 T           number,
 U           number,
 FF          number,
 DD          number,
 LON         number,
 LAT         number,
 ALT         number,
 CQ_P        number,
 CQ_T        number,
 CQ_U        number,
 CQ_FF       number)
tablespace DATA_ALT
pctfree 2
pctused 4
storage (initial 100M next 10M pctincrease 0);