Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Plz help finding replication solution!

Re: Plz help finding replication solution!

From: tacnaboyz <fake.address_at_fake.fake>
Date: Tue, 31 Dec 2002 04:08:59 GMT
Message-ID: <vL8Q9.4157$134.484266@newsread1.prod.itd.earthlink.net>


Oops!! Sorry.. I make it a point to always include that info... dropped the ball this time. Anyway, it's 8.1.7.

Thanks for the info.

"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
news:3e105dfa$2_2_at_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 - 22:08:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US