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
*/