select 'ALTER TABLE '||TABLE_NAME||' drop 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='P';
select 'ALTER TABLE '||TABLE_NAME||' drop CONSTRAINT '||constraint_name||';'
from user_constraints WHERE CONSTRAINT_TYPE='U';
select 'drop index '||index_NAME||';'
from user_indexes a
where a.uniqueness='UNIQUE'