Re: Plz help finding replication solution!

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Mon, 30 Dec 2002 10:10:20 -0000
Message-ID: <3e105dfa$2_2@mk-nntp-1.news.uk.worldonline.com>

"tacnaboyz" <fake.address_at_fake.fake> wrote in message news:I4OP9.2268$134.293352_at_newsread1.prod.itd.earthlink.net...
> Is it possible to replicate data from table1 INTO a pre-existing table2?
I
> read up a bit on replication and it looks like a replicated table has to
be
> a special replicated object. In other words, I have table2 that already
> exists and I want to set up a replication process (read-only) that mirrors
> some columns of table1 into some columns in table2. I'll spare you the
> nasty details as to why I can't be like everyone else and use the
> 'traditional' replication methods. This process MUST take place on the
> existing table2.
>
> Thank You!!!
>
>
>

Version, version version?
You can use Oracle replication into a table which already exists; look up the 'prebuilt' option in your documentation. Otherwise you'll need the (inferior IMHO) DIY method involving triggers and stored procedures.

Regards,
Paul Received on Mon Dec 30 2002 - 04:10:20 CST