How to find out table mview log mismatch columns

SELECT A.TABLE_NAME,a.column_name,a.data_type,c.data_type,a.data_length,c.data_length,b.log_table

from

DBA_TAB_COLUMNS A,DBA_MVIEW_LOGS B,DBA_TAB_COLUMNS C

WHERE A.TABLE_NAME=B.MASTER AND

B.LOG_TABLE=C.TABLE_NAME AND

A.COLUMN_NAME=C.COLUMN_NAME AND

(A.DATA_LENGTH<>C.DATA_LENGTH or a.data_type<>c.data_type);