Tabelle vergleichen

Mit folgendem SQL kann man die Definition zweier Tabellen in der Datenbank vergleichen:

 select * from
 (SELECT  a.column_name, a.data_type,
        a.data_length
   FROM sys.dba_tab_columns a
   where a.owner = 'SCHEMA_1'
     and a.table_name = 'TABELLE_1') a,
 (SELECT  a.column_name, a.data_type,
        a.data_length
   FROM sys.dba_tab_columns a
   where a.owner = 'SCHEMA_2'
     and a.table_name = 'TABELLE_2') b
 where a.column_name = b.column_name (+)
   and (a.data_type <> nvl(b.data_type,'$$$')
        or a.data_length <> nvl(b.data_length,0))
 /