Basically you need to have a dblink established from one db to the rest of the dbs.

Execute few basic sql's say like select table_name,count(column_name) from dba_tab_columns
union
select ..... from dba_tab_columns@dblinkname.

Badrinath