禁用所有外键约束
select
'
alter table
'
||
table_name
||
'
disable constraint
'
||
constraint_name
||
'
;
'
from user_constraints
where
constraint_type
=
'
R
'
;
启用所有外键约束
select
'
alter table
'
||
table_name
||
'
enable constraint
'
||
constraint_name
||
'
;
'
from user_constraints
where
constraint_type
=
'
R
'
;
删除所有外键约束
select
'
alter table
'
||
table_name
||
'
drop constraint
'
||
constraint_name
||
'
;
'
from user_constraints
where
constraint_type
=
'
R
'
;