alter table table_name disable/enable constraint constraint_name;
declare
select 'ALTER TABLE ' || owner || '.' || table_name || ' disable constraint ' || constraint_name as stmt
from dba_constraints
where constraint_type = 'R'
;
begin
for r in fks loop
execute immediate r.stmt;
end loop;
end;
本文介绍如何使用SQL语句altertabletable_namedisable/enableconstraintconstraint_name,通过示例展示了在Oracle数据库中禁用或启用表约束的过程,适合数据库管理员进行日常维护。
1095

被折叠的 条评论
为什么被折叠?



