select 'ALTER TABLE '||c.owner||'.'||c.table_name||' '||
       'MODIFY CONSTRAINT "'||c.constraint_name||'" DISABLE;'        
from all_constraints c
where 
   c.OWNER= '...' and
   c.TABLE_NAME in (...,  -- здесь список всех связанных таблиц
                    ...,
                    ...
                    );

SELECT constraint_name, status  FROM USER_CONSTRAINTS WHERE TABLE_NAME = 'TICKET';

select 
   table_name, 
   constraint_name, 
   status, 
   owner
from 
   USER_CONSTRAINTS
where
   constraint_type = 'R' and
   r_constraint_name in
   (
      select constraint_name 
      from USER_CONSTRAINTS
      where 
         constraint_type in ('P', 'U') and
         table_name = 'TICKET'
   )
order by 
   table_name, 
   constraint_name