Air_create

  CREATE TABLE "AIR"."AVION" ("NUMAVION" NUMBER(6, 0) NOT NULL ENABLE,
  "NOMAVION" VARCHAR2(20) NOT NULL ENABLE, "CAPACITE" NUMBER(3, 0) NOT
  NULL ENABLE, "LOCALISATION" VARCHAR2(35), "DATEMISESERVICE" DATE)
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536
  NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL
  DEFAULT) TABLESPACE "AIR_DATA" LOGGING NOCOMPRESS ;
  ALTER TABLE "AIR"."AVION" MODIFY ("LOCALISATION" DEFAULT 'Paris') ;
  ... 1 ROWS
CONNECT AIR;
CREATE UNIQUE INDEX "AIR"."PK_AVION" ON "AVION" ("NUMAVION" ) PCTFREE 10
INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "AIR_DATA"
LOGGING ;
  ALTER TABLE "AIR"."AVION" ADD CHECK (Capacite IN (140, 180, 200, 250,
  300, 320, 360, 450, 460)) ENABLE ;
  ALTER TABLE "AIR"."AVION" ADD CONSTRAINT "PK_AVION" PRIMARY KEY
  ("NUMAVION") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST
  GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "AIR_DATA" LOGGING ENABLE ;
  CREATE TABLE "AIR"."COMPETENT_IOT" ("NUMPILOTE" NUMBER(4, 0),
  "NUMTYP" CHAR(4), CONSTRAINT "PK_COMPETENT_IOT" PRIMARY KEY
  ("NUMPILOTE", "NUMTYP") ENABLE ) ORGANIZATION INDEX PCTFREE 10
  INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS
  1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
  "AIR_DATA" LOGGING NOCOMPRESS PCTTHRESHOLD 50 ;
  ... 0 ROWS
  CREATE TABLE "AIR"."PILOTE" ("NUMPILOTE" NUMBER(4, 0) NOT NULL
  ENABLE, "NOMPILOTE" VARCHAR2(20) NOT NULL ENABLE, "ADRESSE"
  VARCHAR2(50), "DATECREATION" DATE NOT NULL ENABLE, "DATEDERMAJ"
  TIMESTAMP (6) NOT NULL ENABLE, "CV" CLOB) PCTFREE 10 PCTUSED 40
  INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 262144 NEXT 1048576
  MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "AIR_DATA" LOGGING NOCOMPRESS LOB ("CV") STORE AS
  BASICFILE (TABLESPACE "AIR_DATA" ENABLE STORAGE IN ROW CHUNK 8192
  RETENTION NOCACHE LOGGING STORAGE(INITIAL 65536 NEXT 1048576
  MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)) ;
  ... 7 ROWS
CREATE UNIQUE INDEX "AIR"."PK_PILOTE" ON "PILOTE" ("NUMPILOTE" ) PCTFREE
10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "AIR_DATA"
LOGGING ;
  ALTER TABLE "AIR"."PILOTE" ADD CONSTRAINT "PK_PILOTE" PRIMARY KEY
  ("NUMPILOTE") USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 FREELISTS 1 FREELIST
  GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "AIR_DATA" LOGGING ENABLE ;
  CREATE TABLE "AIR"."VOL" ("NUMVOL" CHAR(6) NOT NULL ENABLE,
  "NUMAVION" NUMBER(6, 0) NOT NULL ENABLE, "NUMPILOTE" NUMBER(4, 0),
  "VILLEDEP" VARCHAR2(35) NOT NULL ENABLE, "VILLEARR" VARCHAR2(35) NOT
  NULL ENABLE, "HEUREDEP" CHAR(5), "HEUREARR" CHAR(5)) PCTFREE 10
  PCTUSED 40 INITRANS 1 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576
  MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
  TABLESPACE "AIR_DATA" LOGGING NOCOMPRESS ;
  ... 6 ROWS
CREATE INDEX "AIR"."UX_NUMAVION" ON "VOL" ("NUMAVION" ) PCTFREE 10
INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "AIR_IND"
LOGGING ;
CREATE INDEX "AIR"."IDX_NUMPILOTE" ON "VOL" ("NUMPILOTE" ) PCTFREE 10
INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1
FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE "AIR_DATA"
LOGGING ;
  CREATE GLOBAL TEMPORARY TABLE "AIR"."VOLPIL#" ("NUMVOL" CHAR(6),
  "VILLEDEP" VARCHAR2(35), "VILLEARR" VARCHAR2(35)) ON COMMIT DELETE ROWS ;
  CREATE GLOBAL TEMPORARY TABLE "AIR"."VOLPIL##" ("NUMVOL" CHAR(6),
  "VILLEARR" VARCHAR2(35), "HEUREARR" CHAR(35)) ON COMMIT PRESERVE ROWS ;
  ALTER TABLE "AIR"."VOL" ADD CONSTRAINT "FK_UTILISE" FOREIGN KEY
  ("NUMAVION") REFERENCES "AVION" ("NUMAVION") ENABLE NOVALIDATE ;
  ALTER TABLE "AIR"."VOL" ADD CONSTRAINT "FK_EFFECTUE" FOREIGN KEY
  ("NUMPILOTE") REFERENCES "PILOTE" ("NUMPILOTE") ENABLE NOVALIDATE ;
CREATE BITMAP INDEX "AIR"."BITMAP_LOCALISATION" ON "AVION" ("LOCALISATION"
) PCTFREE 10 INITRANS 2 MAXTRANS 255 STORAGE(INITIAL 65536 NEXT 1048576
MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT) TABLESPACE
"AIR_DATA" LOGGING ;
  ALTER TABLE "AIR"."VOL" ENABLE CONSTRAINT "FK_UTILISE" ;
  ALTER TABLE "AIR"."VOL" ENABLE CONSTRAINT "FK_EFFECTUE" ;