Re: Synchronizing 2 tables in same database -how ?

chse30_at_hotmail.com (Christian Svensson) wrote in message news:<ccc2a7eb.0311190644.1b93a46a_at_posting.google.com>...
> Greetings all,
>
> We have 2 tables in the same database that we want to synchronize.
> After looking at Oracle Replication as a possible method, it seems
> that Oracle Replication can only be used when replicating objects
> between databases.
>
> Am I correct ?
>
> The table are rather large, ~60Gb, so exp/imp as another name is not
> an option.
>
> So I hope there are Oracle guys out there who can give me some hints
> or recommendations of what the best way to synchronize 2 tables within
> the same database.

Use the minus command each way to select a set to load in the other.

http://groups.google.com/groups?q=minus+group:comp.databases.oracle.server+author:Wolfgang&hl=en&lr=&ie=UTF-8&oe=UTF-8&scoring=d&selm=Xns9429BEADFACE3breitliwcentrexcccom%40198.161.157.145&rnum=1

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/wed/business/news_1b19techjobs.html