Foreign key constraints
select ‘alter table grt_mrc_ist.’||table_name||’ drop constraint ‘||constraint_name||’;’ from dba_constraints
where r_constraint_name in (select constraint_name from dba_constraints where table_name=’LIMIT_SET’ and owner=’GRT_MRC_IST’)
and r_owner=’GRT_MRC_IST’