create database link dbser_link
connect to huike identified by huike
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.22.1.248)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)';
select t.table_name from user_tables@DBSER_LINK t where t.table_name not in (select tt.table_name from user_tables tt)