"
CREATE TABLE "SC"."REFERENCE_LIEU"
( "REFERENCE" NUMBER(*,0) NOT NULL ENABLE,
"LIEU" NUMBER(*,0) NOT NULL ENABLE,
CONSTRAINT "REFERENCE_LIEU_UN" UNIQUE ("REFERENCE")
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 "USERS" ENABLE,
CONSTRAINT "REFERENCE_LIEU_LIEU_FK" FOREIGN KEY ("LIEU")
REFERENCES "SC"."LIEU_MESURE" ("IDENTIFIANT") ENABLE,
CONSTRAINT "REFERENCE_LIEU_REFERENCE_FK" FOREIGN KEY ("REFERENCE")
REFERENCES "SC"."REFERENCE" ("IDENTIFIANT") 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 "USERS"
"
Partager