select 'create table hfmis.' || table_name || ' as select * from ' || table_name || '@link1;' from 
 (select table_name from user_tables@link1
				minus
	select table_name from all_tables where owner = 'HFMIS')

?

?