oracle 脚本键引用编辑操作(copy来的)
select 'alter table ' || t.table_name || ' drop constrant ' || t.constraint_name || ';'
from user_constraints t where t.constraint_type = 'R';
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'
/**
Type Code Type Description Acts On Level
C Check on a table Column
O Read Only on a view Object
P Primary Key Object
R Referential AKA Foreign Key Column
U Unique Key Column
V Check Option on a view Object
*/