SET HEADING OFF
SET PAGESIZE 80
SET FEED OFF

SELECT 'alter table '||cc.owner||'.'||cc.table_name||chr(10)|| ' disable constraint '||cc.constraint_name||';'
FROM dba_cons_columns cc
WHERE cc.constraint_name in (SELECT c.constraint_name
							   FROM dba_constraints c
							   WHERE c.r_constraint_name = 'CONSTRAINT_NOME' and constraint_type='R' and owner = 'SCHEMA')
/
SET HEADING ON
SET FEED ON


--alter table SCHEMA.CONSTRAINT_NOME;
--disable constraint FK_XXX;