Re: Synchronizing 2 tables in same database -how ?

It seems an unusual exercise, would you care to explain why you want to do it.

One options (which I haven't tried) is to create loopback database links, so the database appears to be two other databases - then you might be able to do multi-master replication.

More simply, and less resource intensive perhaps, create triggers on the tables to do synchronized locking and updates by primary key. Set a global variable in each trigger to say 'I am coming from a trigger' so that the triggered update to one doesn't replicate itself back in an infinite loop. You may run into some interesting scalability and deadlock problems, of course.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html
____Belgium__November (EOUG event - "Troubleshooting")
____UK_______December (UKOUG conference - "CBO")


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Christian Svensson" <chse30_at_hotmail.com> 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.

>

> Oracle 8.1.7.4

> Sun Solaris 2.6 (yes I know its old)

>

> Thanks !

>

> /Christian