SYS @ orcl2 > alter user hr account unlock;
SYS @ orcl2 > alter user hr identified by hr;
[orcl2:~]$ exp sh/sh owner=sh file=sh.dmp
[orcl2:~]$ exp hr/hr owner=hr file=hr.dmp
[orcl3:~]$
SYS @ orcl3 > drop user sh cascade;
SYS @ orcl3 > create user sh identified by sh;
SYS @ orcl3 > grant dba to sh;
SYS @ orcl3 > drop user hr cascade;
SYS @ orcl3 > create user hr identified by hr;
SYS @ orcl3 > grant dba to hr;
[orcl3:~]$ imp system/oracle file=sh.dmp fromuser=sh touser=sh
[orcl3:~]$ imp system/oracle file=hr.dmp fromuser=hr touser=hr
SH @ orcl3 >
create database link orcl2_link_sh connect to sh identified by sh using 'edydr1p0.us.oracle.com:1521/orcl2';
HR @ orcl3 >
create database link orcl2_link_hr connect to hr identified by hr using 'edydr1p0.us.oracle.com:1521/orcl2';
SH @ orcl3 >
select table_name, num_rows from user_tables@orcl2_link_sh
minus
select table_name, num_rows from user_tables;
SH @ orcl3 >
select table_name, num_rows from user_tables
minus
select table_name, num_rows from user_tables@orcl2_link_sh;
HR @ orcl3 >
select table_name, num_rows from user_tables@orcl2_link_hr
minus
select table_name, num_rows from user_tables;
HR @ orcl3 >
select table_name, num_rows from user_tables
minus
select table_name, num_rows from user_tables@orcl2_link_hr;