Not able to enable constraint.
HI,
CREATE TABLE "CHRY_STAGE_STG"."CODE_FAMILY"
( "CODE_FAMILY_ID" NUMBER,
"FAMILY_LOOKUP_ID" NUMBER,
"CODE_LOOKUP_ID" NUMBER,
PRIMARY KEY ("CODE_FAMILY_ID") DISABLE,
FOREIGN KEY ("FAMILY_LOOKUP_ID")
REFERENCES "CHRY_STAGE_STG"."FAMILY_LOOKUP" ("FAMILY_LOOKUP_ID") DISABLE,
FOREIGN KEY ("CODE_LOOKUP_ID")
REFERENCES "CHRY_STAGE_STG"."CODE_LOOKUP_OLD" ("CODE_LOOKUP_ID") DISABLE
) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS NOLOGGING
STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT)
TABLESPACE "CHRY_STAGE_STG"
SQL> ALTER TABLE CHRY_STAGE_STG.code_family enable CONSTRAINT CODE_FAMILY_ID ;
ALTER TABLE CHRY_STAGE_STG.code_family enable CONSTRAINT CODE_FAMILY_ID
*
ERROR at line 1:
ORA-02430: cannot enable constraint (CODE_FAMILY_ID) - no such constraint
In the above scenario, do I need to drop the constraints and create the new one?
hare krishna
Alok