Home » SQL & PL/SQL » SQL & PL/SQL » Compare table from two Instances
Compare table from two Instances [message #38982] Tue, 04 June 2002 04:44 Go to next message
Anke
Messages: 8
Registered: November 1999
Junior Member
It's possible to compare table a from instance x with table b from instance y?
If it's possible, you have a little excample?

Thanks
Anke

Report message to a moderator

Re: Compare table from two Instances [message #38986 is a reply to message #38982] Tue, 04 June 2002 05:34 Go to previous messageGo to next message
Miguel
Messages: 14
Registered: April 2001
Junior Member
Can you give a little more explanation?
Table : db table or collection?
Instances: oracle sessions?

Report message to a moderator

Re: Compare table from two Instances [message #38988 is a reply to message #38982] Tue, 04 June 2002 10:24 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
-- what's not identical to what's in table across db link?
select * from my_tab
minus
select * from my_tab@db_link;

-- what's not identical across db link to what's in local table?
select * from my_tab@db_link
minus
select * from my_tab;

Report message to a moderator

Previous Topic: DeadLock giving trouble!!!!!! Very urgent !!!!
Next Topic: inserting value into LONG column
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Apr 25 23:45:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.