可以
CREATE TABLE LL_01
(
AREA CHAR(1 BYTE),
DES VARCHAR2(20 BYTE)
)
TABLESPACE TBS_APPL
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
CREATE UNIQUE INDEX FK_LL01 ON LL_01
(AREA)
LOGGING
TABLESPACE TBS_APPL
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
ALTER TABLE LL_01 ADD (
CONSTRAINT FK_LL01
UNIQUE (AREA)
USING INDEX
TABLESPACE TBS_APPL
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
CREATE TABLE LL_02
(AREA CHAR(1),
DES VARCHAR2(20)
)
ALTER TABLE LL_02 ADD (
CONSTRAINT FK_01
FOREIGN KEY (AREA)
REFERENCES LL_01 (AREA));
CREATE TABLE LL_01
(
AREA CHAR(1 BYTE),
DES VARCHAR2(20 BYTE)
)
TABLESPACE TBS_APPL
PCTUSED 0
PCTFREE 10
INITRANS 1
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
LOGGING
NOCOMPRESS
NOCACHE
NOPARALLEL
NOMONITORING;
CREATE UNIQUE INDEX FK_LL01 ON LL_01
(AREA)
LOGGING
TABLESPACE TBS_APPL
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
BUFFER_POOL DEFAULT
)
NOPARALLEL;
ALTER TABLE LL_01 ADD (
CONSTRAINT FK_LL01
UNIQUE (AREA)
USING INDEX
TABLESPACE TBS_APPL
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
CREATE TABLE LL_02
(AREA CHAR(1),
DES VARCHAR2(20)
)
ALTER TABLE LL_02 ADD (
CONSTRAINT FK_01
FOREIGN KEY (AREA)
REFERENCES LL_01 (AREA));
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货