oracle 9i/10g에서 테이블 생성하려고하는데
CREATE TABLE SKILLS (
ConsultantID CHAR(4) NOT NULL,
ExpertiseID CHAR(4) NOT NULL,
MonthsExperience Numeric(2) NOT NULL,
CONSTRAINT SKILLSPK PRIMARY KEY(ConsultantID, ExpertiseID),
CONSTRAINT CONSULTANTSFK FOREIGN KEY (ConsultantID)
REFERENCES CONSULTANTS (ConsultantID)
ON UPDATE NO ACTION
ON DELETE NO ACTION,
CONSTRAINT EXPERTISEFK FOREIGN KEY (ExpertiseID)
REFERENCES EXPERTISE(ExpertiseID)
ON UPDATE NO ACTION
ON DELETE NO ACTION
)
go
이렇게하는데
[Error] Script lines: 1-11 -------------------------
ORA-00905: missing keyword
에러뜨네요.. 모가 문제 인지 알려주시면 감사하겠습니다!~ |