Oracle - Table Foreign Key Stop/Start

[ Oracle - Table  Foreign Key Stop/Start  ]

 

1. foreignkey : 잠시 stop     ALTER TABLE  table_name    DISABLE CONSTRAINT  foreign_key_name;   2. foreignkey : restart     ALTER TABLE  table_name    ENABLE CONSTRAINT  foreign_key_name;        * foreign key stop sql 문장 생성 SELECT 'ALTER TABLE  QMDBA.' || TABLE_NAME || '   ENABLE CONSTRAINT ' || CONSTRAINT_NAME || ';'   FROM ALL_CONSTRAINTS  WHERE OWNER = 'QMDBA'    AND CONSTRAINT_TYPE = 'R'  ORDER BY CONSTRAINT_NAME ;