drop a lot of constrains

[Shestakov]

select 'alter table '||c.owner||'.'||c.table_name||' drop constraints '||c.constraint_name||';'
from all_constraints c
where c.owner = 'YOUR_OWNER'
;

select 'alter table '||t.owner||'.'||t.table_name||' drop constraints '||c.constraint_name||';'
from all_tables t,
all_constraints c
where t.owner = c.owner and
t.table_name = c.table_name
and t.owner = 'YOUR_OWNER'
;