correction d'anomalie sur la taille de colonnes liées par des contraintes d'intégrité référentielles

select c1.table_name,c1.column_name,d1.table_name,d1.column_name,c1.data_type,c1.data_length,d1.data_type,d1.data_length
from user_tab_columns c1,user_cons_columns c,user_tab_columns d1,user_cons_columns d,user_constraints a, user_constraints b
where a.R_CONSTRAINT_NAME=b.CONSTRAINT_NAME
and a.CONSTRAINT_NAME=c.CONSTRAINT_NAME
and c.table_NAME=c1.table_NAME
and c.column_NAME=c1.column_NAME
and b.CONSTRAINT_NAME=d.CONSTRAINT_NAME
and d.table_NAME=d1.table_NAME
and d.column_NAME=d1.column_NAME
and a.CONSTRAINT_TYPE='R'
minus
select c1.table_name,c1.column_name,d1.table_name,d1.column_name,d1.data_type,d1.data_length,c1.data_type,c1.data_length
from user_tab_columns c1,user_cons_columns c,user_tab_columns d1,user_cons_columns d,user_constraints a, user_constraints b
where a.R_CONSTRAINT_NAME=b.CONSTRAINT_NAME
and a.CONSTRAINT_NAME=c.CONSTRAINT_NAME
and c.table_NAME=c1.table_NAME
and c.column_NAME=c1.column_NAME
and b.CONSTRAINT_NAME=d.CONSTRAINT_NAME
and d.table_NAME=d1.table_NAME
and d.column_NAME=d1.column_NAME
and a.CONSTRAINT_TYPE='R'
;