[Oracle_Error] ORA-02264: name already used by an existing constraint
·
Trouble Shooting(Error)
에러메시지 : ORA-02264: name already used by an existing constraint 원인 : 제약조건명이 동일한 것이 사용되어짐 해결 : 제약조건명 확인후 변경하기 CREATE TABLE tbl_column_level( empno NUMBER(4) NOT NULL CONSTRAINTS pk_tblcolumnlevel_empno PRIMARY KEY , ename VARCHAR2(20) NOT NULL , deptno NUMBER(2) NOT NULL CONSTRAINTS fk_tblcolumnlevel_deptno REFERENCES dept(deptno) , kor NUMBER(3) CONSTRAINTS ck_tblcolumnlevel_kor CHECK (kor BETWEE..