drop table vol;
create table vol(
	numvol		varchar2(8),
	heure_depart	date NOT NULL,
	heure_arrivee	date NOT NULL,
	ville_depart	varchar2(20) NOT NULL,
	ville_arrivee	varchar2(20) NOT NULL,
	constraint volpk primary key (numvol));

insert into vol (select * from system.vol); 

drop table escales;
create table escales(
	numescale	number(9),
	ville_escale	varchar2(20) NOT NULL,
	duree_escale	number(2) NOT NULL,
	constraint escalespk primary key (numescale));

insert into escales (select * from system.escales);

commit;
