Oracle dblink比較兩個庫中的表欄位

create user olduser identified by old123;

grant connect, resource to olduser;

connect olduser/old123;

create table oldtable(oldid number);

insert into oldtable values(1);

insert into oldtable values(2);

insert into oldtable values(3);

commit;

create user newuser identified by new123;

grant connect, resource to newuser;

connect newuser/new123;

create table newtable(newid number);

insert into newtable values(2);

insert into newtable values(3);

insert into newtable values(4);

commit;

OLD =

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.30.65)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = orcl)

    )

  )

conn system/oracle

create public database link old_db connect to olduser identified by old123 using 'old';

conn newuser/new123;

select oldid from oldtable@old_db where oldid not in (select newid from newtable);

     OLDID

----------

       1

 select newid from newtable where newid not in (select oldid from oldtable@old_db);

     NEWID

----------

       4