hii,,
i have droppd a primary key constraint & when i try and insert a duplicate
record it still gives error of Unique key violaion..can anyone please explain me why
am i not able to insert..?
CONSTRAINT_NAME TABLE_NAME COLNM
------------------------------ ------------------------- ---------------
SYS_C005380 LOAN_DETAIL LND_TYPE
SYS_C005379 LOAN_DETAIL LND_LNH_EMP_CODE
SYS_C005378 LOAN_DETAIL LND_LNH_NO
SYS_C005377 LOAN_DETAIL LND_LNH_CODE
*LND_PK LOAN_DETAIL LND_TYPE*
*LND_PK LOAN_DETAIL LND_LNH_EMP_CODE*
LNDH_FK LOAN_DETAIL LND_LNH_CODE
LNDH_FK LOAN_DETAIL LND_LNH_EMP_CODE
LNDH_FK LOAN_DETAIL LND_LNH_NO
9 rows selected.
SQL> ALTER TABLE LOAN_DETAIL
2 DROP CONSTRAINT LND_PK;
Table altered.
SQL> desc loan_detail
Name Null? Type
----------------------------------------------------------------- -------- ------------------------
LND_LNH_CODE NOT NULL VARCHAR2(6)
LND_LNH_NO NOT NULL NUMBER(6)
LND_DATE DATE
LND_LNH_EMP_CODE NOT NULL VARCHAR2(12)
LND_TYPE NOT NULL VARCHAR2(6)
select LND_LNH_CODE,LND_LNH_NO,LND_DATE,LND_LNH_EMP_CODE,LND_TYPE
from loan_detail
where LND_LNH_NO = 6;
LND_LN LND_LNH_NO LND_DATE LND_LNH_EMP_ LND_TY
------ ------------- ---------- ------------ ------
LAP 6.000 23/03/2009 1946 30
LAP 6.000 23/03/2009 1946 40
SQL> insert into LOAN_DETAIL (LND_LNH_CODE,LND_LNH_NO,LND_DATE,LND_LNH_EMP_CODE,LND_TYPE) values
('LAP',6,TO_DATE('17/08/2010','DD/MM/YYYY'), '1946',30);
insert into LOAN_DETAIL (LND_LNH_CODE,LND_LNH_NO,LND_DATE,LND_LNH_EMP_CODE,LND_TYPE)
*
ERROR at line 1:
ORA-00001: unique constraint (SCOTT.LND_PK) violated