create database link testlink_24_25
connect to system identified by oracle
using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.25)(PORT=1521))(CONNECT_DATA=(SID=lvgitst2)))';


create database link testlink_25_24
connect to system identified by oracle
using '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.30.24)(PORT=1521))(CONNECT_DATA=(SID=lvgitrn)))'

------------------------------
in LVGITST2 but not in LVGITRN
------------------------------

create table lvgitrn as
select owner,table_name from dba_tables where owner in ('INS','CONFSYS','REINS','RNL','DW_REP') and table_name not like 'BIN%'
minus
select owner,table_name from dba_tables@testlink_25_24 where owner in ('INS','CONFSYS','REINS','RNL','DW_REP') and table_name not like 'BIN%'


select a.owner,a.table_name,column_name,column_id from dba_tab_columns a, dba_tables b  
where a.OWNER=b.owner
and a.TABLE_NAME=b.table_name
and a.owner in ('INS','CONFSYS','REINS','RNL','DW_REP') 
and a.table_name not like 'BIN%' and a.owner||a.table_name not in (select owner||table_name from lvgitrn)
minus
select a.owner,a.table_name,column_name,column_id from dba_tab_columns@testlink_25_24 a, dba_tables@testlink_25_24 b  
where a.OWNER=b.owner
and a.TABLE_NAME=b.table_name
and a.owner in ('INS','CONFSYS','REINS','RNL','DW_REP') 
and a.table_name not like 'BIN%' and a.owner||a.table_name not in (select owner||table_name from lvgitrn)

------------------------------
in LVGITRN but not in LVGITST2
------------------------------


create table lvgitst2 as
select owner,table_name from dba_tables where owner in ('INS','CONFSYS','REINS','RNL','DW_REP') and table_name not like 'BIN%'
minus
select owner,table_name from dba_tables@testlink_24_25 where owner in ('INS','CONFSYS','REINS','RNL','DW_REP') and table_name not like 'BIN%'


select a.owner,a.table_name,column_name,column_id from dba_tab_columns a, dba_tables b  
where a.OWNER=b.owner
and a.TABLE_NAME=b.table_name
and a.owner in ('INS','CONFSYS','REINS','RNL','DW_REP') 
and a.table_name not like 'BIN%' and a.owner||a.table_name not in (select owner||table_name from lvgitst2)
minus
select a.owner,a.table_name,column_name,column_id from dba_tab_columns@testlink_24_25 a, dba_tables@testlink_24_25 b  
where a.OWNER=b.owner
and a.TABLE_NAME=b.table_name
and a.owner in ('INS','CONFSYS','REINS','RNL','DW_REP') 
and a.table_name not like 'BIN%' and a.owner||a.table_name not in (select owner||table_name from lvgitst2)