Orszag AdatB SQL

// ------------------ORSZAG------------------

CREATE TABLE "C29106"."ORSZAG"
   (    "NEV" VARCHAR2(20 BYTE),
    "FOVAROS" VARCHAR2(40 BYTE),
    "TERULET" NUMBER,
    "LELEKSZAM" NUMBER,
    "TENGERPART" NUMBER(1,0),
    "KONTINENS" VARCHAR2(30 BYTE),
     CONSTRAINT "ORSZAGNEV" PRIMARY KEY ("NEV")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "OKT"  ENABLE,
     CONSTRAINT "TENGERPART_INTERV" CHECK ("TENGERPART" = 1 OR "TENGERPART" = 0) ENABLE,
     CONSTRAINT "ORSZAGNEV_NEM_NULL" CHECK ("NEV" IS NOT NULL) ENABLE,
     CONSTRAINT "ORSZAG_FK1" FOREIGN KEY ("KONTINENS")
      REFERENCES "C29106"."KONTINENS" ("NEV") ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "OKT" ;

// ----------------KONTINENS----------------

  CREATE TABLE "C29106"."KONTINENS"
   (    "NEV" VARCHAR2(30 BYTE),
    "FELFEDEZES_EVE" NUMBER(4,0),
     CONSTRAINT "KONTINENSNEV" PRIMARY KEY ("NEV")
  USING INDEX PCTFREE 10 INITRANS 2 MAXTRANS 255 COMPUTE STATISTICS
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "OKT"  ENABLE,
     CONSTRAINT "KONTINENS_CHK1" CHECK ("NEV" IS NOT NULL) ENABLE
   ) SEGMENT CREATION IMMEDIATE
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255
 NOCOMPRESS LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1
  BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "OKT" ;