Create and use database link

connect system/pwd@sid1
grant create database link to user1;

connect user1/pwd@sid1;
DROP DATABASE LINK dblink1;
CREATE DATABASE LINK dblink1
    CONNECT TO user2 IDENTIFIED BY pwd
    USING 'SID2';
create table table1 as select * from table1@user2;