cannot clean out schema

[sukimac]

Try to disable the constraints that are prevented the drop- look in user_constraints I use the following to disable all of a schemas foreign key constraints

select 'alter table '|| r_owner ||'.'||
table_name ||' disable constraint '||
constraint_name ||';'
from user_constraints
where r_owner = upper('SCHEMA_OWNER')
and constraint_type = 'R';