how to disable primary key?
536805Jan 4 2007 — edited Jan 4 2007Hi all...
I want to disable primary key .
CONSTRAINT_NAME C STATUS
------------------------------ - --------
BILL_FK01 R ENABLED
SYS_C0091766 C ENABLED
SYS_C0091767 C ENABLED
SYS_C0091768 C ENABLED
SYS_C0091769 C ENABLED
SYS_C0091770 C ENABLED
SYS_C0091771 C ENABLED
SYS_C0091761 C ENABLED
SYS_C0091762 C ENABLED
SYS_C0091763 C ENABLED
BILL_PK01 P ENABLED --- primary key
where i used following command it shows error
alter table bill_info_history
disable constraint bill_pk01;
alter table bill_info_history
*
ERROR at line 1:
ORA-02431: cannot disable constraint (BILL_PK01) - no such constraint
S.